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)

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