The following are multi table queries $(17-20),$ make sure to use the Join command $($all joins are

Natural or Inner Joins$)$

$17.$ Using the Customer and the Address table $($you will need to Join the tables$),$ list the

customer$\_$id$,$ first$\_$name, last$\_$name, address, district, city$\_$id$,$ postal$\_$code, phone, and email.

Join on the address$\_$id from both tables. Order by last$\_$name then first$\_$name.

$18.$ Using the Customer and the Address table $($you will need to Join the tables$),$ list the

customer$\_$id$,$ first$\_$name, last$\_$name, address, district, city$\_$id$,$ postal$\_$code, phone, and email for

those customers that live in California. Join on the address$\_$id from both tables. Order by

last$\_$name then first$\_$name.

$19.$ Using the Customer and the Address table $($you will need to Join the tables$),$ list the

customer$\_$id$,$ first$\_$name, last$\_$name, address, district, city$\_$id$,$ postal$\_$code, phone, and email

where the city$\_$id is greater than $500.$ Join on the address$\_$id from both tables. Order by

city$\_$id$.$

$20.$ Using the actor and film$\_$actor table, join using the actor$\_$id field from both tables. List the

actor$\_$id$,$ first$\_$name, last$\_$name, and film$\_$id$.$ Order by film$\_$id$,$ actor$\_$id