Error in 'Queries Quality and Percentage, Question No: 1211 on Leetcode, Question No : 19 of "SQL Top 50"

[parthivshah33]

Edited Code from My Side/Final Code :

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

--> Added "WHERE" clause.