Write SELECT statements that implement the following queries. (1) Find the registration numbers of trucks, that have capacity in a range between 100 inclusive and 500 inclusive. (2) Find the first and...

Write SELECT statements that implement the following queries.
(1) Find the registration numbers of trucks, that have capacity in a range between 100
inclusive and 500 inclusive.
(2) Find the first and the last names of all drivers who are on leave.
(3) Find the registration numbers of all trucks that have not been used for any trips.
(4) Find the registration numbers of all trucks together with total number of trips the trucks
have been used for. There is no need to include the truck that have not been used for
any trips.
(5) Find the names of all departure cities together with the names of all destination cities.