leetcode-1211. 查询结果的质量和占比

 

 

1211. 查询结果的质量和占比

https://leetcode.cn/problems/queries-quality-and-percentage/

 

SELECT query_name

, round(avg(rating / position), 2) AS quality

, round(avg(rating < 3) * 100, 2) AS poor_query_percentage

FROM Queries

GROUP BY query_name