Skip to content

Instantly share code, notes, and snippets.

@danny8376

danny8376/divisions-number.sql

Created December 4, 2014 20:20
Show Gist options
  • Save danny8376/c74096b5b0feabc0b002 to your computer and use it in GitHub Desktop.
Save danny8376/c74096b5b0feabc0b002 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
divisions-number.sql
-- SQLFiddle : http://sqlfiddle.com/#!2/f0e3bd/4
-- SQLを書こう！
SELECT d.division_name, count(*)
FROM division AS d LEFT JOIN member AS m
ON d.division_id = m.division_id
GROUP BY d.division_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment