filmov
tv
SQL Interview | 'Queries Quality and Percentage I' | SQL 50 | Leetcode Easy Problem 1211 | CASE
Показать описание
Leetcode Easy Problem
Write a solution to find each query_name, the quality, and poor_query_percentage.
Both quality and poor_query_percentage should be rounded to 2 decimal places.
Return the result table in any order.
I have used CASE statement and aggregate function to solve the problem
The runtime of my solution beats 69.98% of the users and memory beats 100% of the users.
This series will help you in SQL Interviews. All of these questions are present on Leetcode. Please go through the videos. Let me know your feedback and anything specific that you would like to see in the comments section. Please like and share
Write a solution to find each query_name, the quality, and poor_query_percentage.
Both quality and poor_query_percentage should be rounded to 2 decimal places.
Return the result table in any order.
I have used CASE statement and aggregate function to solve the problem
The runtime of my solution beats 69.98% of the users and memory beats 100% of the users.
This series will help you in SQL Interviews. All of these questions are present on Leetcode. Please go through the videos. Let me know your feedback and anything specific that you would like to see in the comments section. Please like and share
0:36:33
0:21:53
0:01:00
0:08:23
0:18:31
0:24:29
0:00:05
0:06:39
0:07:47
0:00:23
0:00:06
0:06:53
0:00:13
0:11:13
0:11:48
0:01:00
0:09:39
0:13:28
0:00:58
0:08:38
0:01:00
0:00:06
0:00:44
0:11:45