#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;