SQL Interview Questions and Answers Series | LeetCode | 19. Queries Quality and Percentage

SQL 50 Series | SQL LeetCode Problem Solutions

Sharpen your SQL skills with this problem solution designed to help you ace your next SQL interview. Master essential concepts and solve challenging problems using the popular LeetCode series of 50 SQL Interview Problems.

#sql #sqlinterviewquestions #sqlserver #sqltraining sqlforbeginners #sqltips #sqlite #interviewpreparation #interviewprep #interviewquestionsforfreshers #interviewtips #leetcodequestionandanswers #leetcode #leetcodesql #sqlforbeginners #coding #dataanalysis #datascience #sqlinterviewquestionsandanswersforexperienced #basic #dataanalystinterview #dataanalyticscareers #dataanalysts #dataanalysts

[rahulruke]

There are some test cases which include query_name as null so just add where clause in the query to check query_name not null so complete query will be as follow:
select q.query_name,
round(AVG(q.rating/q.position), 2) as quality,
round(AVG(rating<3)*100, 2) as poor_query_percentage
from queries as q
where q.query_name is not null
group by q.query_name