• Examples
  • Sample Database
#1
SELECT
	count(*)
FROM
	tracks;
#2
SELECT
	count(*)
FROM
	tracks
WHERE
	albumid = 10;
#3
SELECT
	albumid,
	count(*)
FROM
	tracks
GROUP BY
	albumid;
#4
SELECT
	albumid,
	count(*)
FROM
	tracks
GROUP BY
	albumid
HAVING count(*) > 25
#5
SELECT
	tracks.albumid,
	name,
	count(*)
FROM
	tracks
INNER JOIN albums on albums.albumid = tracks.albumid
GROUP BY
	tracks.albumid
HAVING count(*) > 25
ORDER BY COUNT(*) desc;
#6
SELECT
	employeeid,
	lastname,
	firstname,
	title
FROM
	employees;
#7
SELECT
	COUNT(title)
FROM
	employees;
#8
SELECT
	COUNT(DISTINCT title)
FROM
	employees;
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