Skip to content

Instantly share code, notes, and snippets.

@databraineo

databraineo/sql1x1-13.sql

Created August 16, 2019 08:20
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/d90744c4261a09cebc47e31450d9157a to your computer and use it in GitHub Desktop.
Save databraineo/d90744c4261a09cebc47e31450d9157a to your computer and use it in GitHub Desktop.
Download ZIP
Code examples for SQL 1x1 blog-article - 13
Raw
sql1x1-13.sql
SELECT
substr(Name,1,1) as [Index],
count(TrackId) AS Anzahl,
avg(Milliseconds)/600000 as MW
FROM Track
WHERE substr(Name,1,1) in ('A','E','I','O','U')
GROUP BY substr(Name,1,1)
HAVING count(TrackId) > 50
ORDER BY substr(Name,1,1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment