Final Project

SELECT first_name, last_name FROM owners
WHERE state = 'CA';

SELECT full_name FROM pets
WHERE age > 4;

SELECT o.first_name, o.last_name AS surname, p.full_name FROM owners o
JOIN pets p ON o.id = p.owner_id
WHERE p.age > 4
ORDER BY p.age DESC;