SELECT employeeid, firstname, lastname, title, email FROM employees;
UPDATE employees SET lastname = 'Smith' WHERE employeeid = 3;
SELECT employeeid, firstname, lastname, title, email FROM employees WHERE employeeid = 3;
UPDATE employees SET city = 'Toronto', state = 'ON', postalcode = 'M5P 2N7' WHERE employeeid = 4;
SELECT employeeid, firstname, lastname, state, city, PostalCode FROM employees WHERE employeeid = 4;
SELECT employeeid, firstname, lastname, email FROM employees;
UPDATE employees SET email = lower( firstname || "." || lastname || "@chinookcorp.com" ) ORDER BY firstname LIMIT 1;
UPDATE employees SET email = lower( firstname || "." || lastname || "@chinookcorp.com" );
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;