TRY IT YOURSELF

Explore basic queries with these exercises:

$1.$ The school district superintendent asks for a list of teachers in each school.

Write a query that lists the schools in alphabetical order along with teachers ordered by last name A$$Z$.$

$2.$ Write a query that finds the one teacher whose first name starts with the

letter S and who earns more than $$40,000.$

$3.$ Rank teachers hired since January $1,2010,$ ordered by highest paid to

lowest