I am doing an analysis of shooting incidents in NYC over the last fifteen years and am endeavoring to find the percentage of shootings that resulted in deaths.
I divide count of murders by count of total shootings using the following syntax:
select format(count(MURDERED)/count(*), 'P1') MURDER_PCT from PortfolioProjects..NYPD_shootings where MURDERED = 'TRUE'
This returns an answer of 1 (or 100% with percent formatting). What is wrong with my syntax?