1211. Queries Quality and Percentage : leetcode

answer

SELECT 
    query_name,
    ROUND(AVG(rating / position),2) as quality,
    ROUND((SUM(IF(rating<3, 1, 0)) / count(*))* 100, 2) as poor_query_percentage
FROM
    Queries
GROUP BY  
    query_name;