Refreshing my SQL skills

Basics:

SELECT DISTINCT x,y,z from table_name

SELECT COUNT(*) FROM table