Update 1211. Queries Quality and Percentage.sql

iamAntimPal · Antim-IWP · iamAntimPal · commit 024363e66d29 · 2025-03-14T03:44:43.000+05:30
Co-Authored-By: Antim-IWP &lt;203163676+Antim-IWP@users.noreply.github.com&gt;
diff --git a/1211. Queries Quality and Percentage.sql b/1211. Queries Quality and Percentage.sql
@@ -68,4 +68,10 @@ 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
-GROUP BY query_name;
+GROUP BY query_name;
+
+-- SELECT query_name,
+-- ROUND(AVG(rating * 1.0 / position), 2) AS quality,
+-- ROUND(SUM(IF(rating < 3, 1, 0)) * 100.0 / COUNT(*), 2) AS poor_query_percentage  
+-- FROM Queries
+-- GROUP BY query_name;
