Commit 65e0bb1

committed

The HAVING Clause (vs WHERE)

1 parent 4e3aa2e commit 65e0bb1Copy full SHA for 65e0bb1

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -6,3 +6,9 @@ SELECT COUNT(id) FROM locations;`
`6`	`6`	`SELECT c.name, loc.street, COUNT(loc.id) AS num_locations FROM cities AS c`
`7`	`7`	`LEFT JOIN locations AS loc ON loc.city_name = c.name`
`8`	`8`	`GROUP BY c.name, loc.street;`
	`9`	`+`
	`10`	`+SELECT c.name, COUNT(loc.id) AS num_locations FROM cities AS c`
	`11`	`+LEFT JOIN locations AS loc ON loc.city_name = c.name`
	`12`	`+-- WHERE loc.city_name = 'Munich'`
	`13`	`+GROUP BY c.name`
	`14`	`+HAVING COUNT(loc.id) > 1;`

Comments

(0)