Skip to content

Instantly share code, notes, and snippets.

@databraineo

databraineo/sql1x1-12.sql

Created August 16, 2019 08:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save databraineo/5a55b56680ccb0c64165be41ed3d873f to your computer and use it in GitHub Desktop.
Save databraineo/5a55b56680ccb0c64165be41ed3d873f to your computer and use it in GitHub Desktop.
Download ZIP
Code examples for SQL 1x1 blog-article - 12
Raw
sql1x1-12.sql
SELECT
Composer,
count(TrackId) as Anzahl,
avg(Milliseconds)/60000 as MW,
min(Milliseconds)/60000 as Minimum,
max(Milliseconds)/60000 as Maximum
FROM Track
GROUP BY Composer
ORDER BY Composer;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment