SQL_LeetCode 1211_Queries Quality and Percentage

SQL_LeetCode 1211_Queries Quality and Percentage 풀이 -- mysql, oracle SELECT query_name , round(avg(rating / position),2) as quality , round(avg(case when rating < 3 then 1 else 0 end) * 100, 2) as poor_query_percentage FROM Queries WHERE query_name IS NOT NULL GROUP BY query_name; -- mssql SELECT query_name , round(avg(cast(rating as decimal) / position), 2) as quality , round(avg((case when rating < 3 then 1 else 0 end) * cast(100 as decimal)), 2) as poor_query_percentage FROM Queries WHERE que...

원문링크 : SQL_LeetCode 1211_Queries Quality and Percentage