Categorize Juan's dogs with GROUP BY

Let's figure out how many dogs Juan has of each breed! This is the query:

 SELECT breed, count(*) AS num_dogs

 FROM dogs

 WHERE owner = 'juan'

 GROUP BY breed

 ORDER BY count(*) ASC

Let's go through that query one step at a time: