Class Project

Class Project - student project

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

SELECT full_name FROM pets
ORDER BY age DESC
LIMIT (3);

SELECT owners.first_name AS first, owners.last_name AS last, pets.full_name
FROM owners JOIN pets ON owners.id = pets.owner_id
WHERE pets.species LIKE 'D%'
ORDER BY owners.last_name;