SELECT m.firstname || ' ' || m.lastname AS 'Manager', e.firstname || ' ' || e.lastname AS 'Direct report' FROM employees e INNER JOIN employees m ON m.employeeid = e.reportsto ORDER BY manager;
SELECT DISTINCT e1.city, e1.firstName || ' ' || e1.lastname AS fullname FROM employees e1 INNER JOIN employees e2 ON e2.city = e1.city AND (e1.firstname <> e2.firstname AND e1.lastname <> e2.lastname) ORDER BY e1.city;
SELECT * FROM albums;
SELECT * FROM artists;
SELECT * FROM customers;
SELECT * FROM employees;
SELECT * FROM genres;
SELECT * FROM invoice_items;
SELECT * FROM invoices;
SELECT * FROM media_types;
SELECT * FROM playlist_track;
SELECT * FROM playlists;
SELECT * FROM tracks;