leetcodeSolution 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