Find the rate of processed tickets for each type

table name: facebook_complaints


Solution:
select type, convert(float,count(case when processed =1 then 1 end))/count(*)  from facebook_complaints group by type


Comments (0)
Questions List