leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1211.sql (198B)


0 SELECT query_name,
1 ROUND(AVG(rating / position), 2) AS quality,
2 ROUND(AVG(rating < 3) * 100, 2) AS poor_query_percentage
3 FROM Queries
4 WHERE query_name IS NOT NULL
5 GROUP BY query_name