• Examples
  • Sample Database
#1
SELECT
	albumid,
	COUNT(trackid)
FROM
	tracks
GROUP BY
	albumid;
#2
SELECT
	albumid,
	COUNT(trackid)
FROM
	tracks
GROUP BY
	albumid
ORDER BY COUNT(trackid) DESC;
#3
SELECT
	tracks.albumid,
	title,
	COUNT(trackid)
FROM
	tracks
INNER JOIN albums ON albums.albumid = tracks.albumid
GROUP BY
	tracks.albumid;
#4
SELECT
	tracks.albumid,
	title,
	COUNT(trackid)
FROM
	tracks
INNER JOIN albums ON albums.albumid = tracks.albumid
GROUP BY
	tracks.albumid
HAVING COUNT(trackid) > 15;
#5
SELECT
	albumid,
	sum(milliseconds) length,
	sum(bytes) size
FROM
	tracks
GROUP BY
	albumid;
#6
SELECT
	tracks.albumid,
	title,
	min(milliseconds),
	max(milliseconds),
	round(avg(milliseconds),2)
FROM
	tracks
INNER JOIN albums ON albums.albumid = tracks.albumid
GROUP BY
	tracks.albumid;
#7
SELECT
	mediatypeid,
	genreid,
	count(trackid)
FROM
	tracks
GROUP BY
	mediatypeid,
	genreid;
albums artists customers employees genres invoice_items invoices media_types playlist_track playlists tracks
  • SQL Query
Enter a query, then click the execute button or press F9 to run it.
  • Result
Loading