1211-queries-quality-and-percentage

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below
SELECT query_name,
ROUND( AVG(rating/position),2) as quality,
ROUND( AVG(IF(rating<3,100,0)),2) as poor_query_percentage
FROM Queries
GROUP BY query_name