Queries Quality and Percentage – LeetCode SQL Problem 1211

In this video, we solve a popular LeetCode SQL problem that challenges you to calculate the query quality and the poor query percentage based on specific definitions using SQL aggregate functions and grouping logic.

📌 What You’ll Learn:

How to calculate average using SQL

Using conditional aggregation for custom metrics

Rounding results and formatting output

Grouping and filtering data like a pro!

💡 Problem Summary: Given a table Queries with columns like query_name, rating, and position, you'll learn how to compute:

The average ratio of rating to position for each query_name (aka query quality)

The percentage of poor queries (ratings less than 3)

🧠 Difficulty: Medium
🎯 Topic Covered: Aggregation, CASE WHEN, GROUP BY, ROUND

📊 Whether you're preparing for SQL interviews or just brushing up your skills, this problem is a must-solve!

⏱️ Timestamps: 00:00 - Introduction
00:30 - Problem Explanation
02:00 - SQL Strategy Breakdown
04:00 - Code Walkthrough
06:00 - Final Output & Optimization

💬 Got questions? Drop them in the comments — I reply to every single one!
👍 Don’t forget to Like, Share, and Subscribe for more SQL + Data Science tutorials!

#SQL #LeetCode #DataAnalytics #PoorQueries #InterviewPrep #GeekyCodes #LeetCodeSQL #DataScience