题目描述
leetcode题目:1211. 查询结果的质量和占比
Code
写法一
select query_name,
round(sum(rating/`position`)/count(*), 2) as quality,
round(sum(if(rating < 3, 1, 0))/count(*)*100, 2) as poor_query_percentage
from Queries
where query_name is not null
group by query_name
写法二
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
having query_name is not null
注意:
- 测试用例中有 query_name为null 的值,所以需要过滤一下。