Skip to content

Instantly share code, notes, and snippets.

@cabloo

cabloo/get-part-counts.sql

Created July 7, 2018 18:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save cabloo/7dc9288897986ce99f59f6e5e2c5489a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save cabloo/7dc9288897986ce99f59f6e5e2c5489a to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. cabloo created this gist Jul 7, 2018.
    1 change: 1 addition & 0 deletions get-part-counts.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    SELECT parts.name, COUNT(*) FROM part_server INNER JOIN parts on parts.id = part_server.part_id GROUP BY part_id;