SQL
leetcode 1211. Queries Quality and Percentage
무적김두칠
2023. 6. 13. 17:48
Queries Quality and Percentage - LeetCode
Can you solve this real interview question? Queries Quality and Percentage - Table: Queries +-------------+---------+ | Column Name | Type | +-------------+---------+ | query_name | varchar | | result | varchar | | position | int | | rating | int | +------
leetcode.com
|
1
2
3
4
5
6
|
# Write your MySQL query statement below
select query_name
, round(avg(rating/position), 2) quality
, COALESCE(round(100*sum(case when rating<3 then 1 end)/count(query_name), 2), 0) poor_query_percentage
from Queries
group by query_name
|
cs |
반응형