leetcode 1211 查詢結果的質量和佔比

leetcode 1211 查詢結果的質量和佔比

select query_name,round(
    sum(rating / position) / count(result)
, 2) as quality ,round(sum(rating < 3) / count(result) * 100, 2) as poor_query_percentage 
from Queries
group by query_name 

==