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