This question is based on the tables listed below: Give SQL statements for each of the following: (a) List all the cars rented by customer Smith since 1 November 2015. (b) List each make of car, and the total number of cars of that make. (c) List the registration number of all the cars that have never been rented. (d) Change the phone number of customer Jones to 999-1234.
a-select CAR.RegistrationNo, Make from
b-select count(make) as cars , Make from
group by Make;
select CAR.RegistrationNo from
where CAR.RegistrationNo NOT IN (select RegistrationNo from RENTAL);