Grouping results
•
SELECT SIGN(latitude), COUNT(*)
FROM sources
WHERE stargalaxy > 0.9
GROUP BY SIGN(latitude);
•
HAVING clause works like WHERE but on
the
result
of a query
Odd! COUNT works on the group!