Average Selling Price Null error

[tejajagadeep]

didn't handle null, leet code is expecting 0

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

[tanweerkarzai]

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