The HAVING Clause (vs WHERE)

ThomasCode92 · ThomasCode92 · commit 65e0bb111584 · 2023-11-06T17:25:08.000+01:00
diff --git a/data/10-more-queries.sql b/data/10-more-queries.sql
@@ -6,3 +6,9 @@ SELECT COUNT(id) FROM locations;
 SELECT c.name, loc.street, COUNT(loc.id) AS num_locations FROM cities AS c
 LEFT JOIN locations AS loc ON loc.city_name = c.name
 GROUP BY c.name, loc.street;
+
+SELECT c.name, COUNT(loc.id) AS num_locations FROM cities AS c
+LEFT JOIN locations AS loc ON loc.city_name = c.name
+-- WHERE loc.city_name = 'Munich'
+GROUP BY c.name
+HAVING COUNT(loc.id) > 1;
