Answer to Question #349030 in Databases | SQL | Oracle | MS Access for jane

Question #349030

5. Write a query that will return all the rentals placed between the following dates “2021-08-

01” AND “2021-10-30”.

6. Write a query that selects all the rentals placed by Bud Barnes.

7. Write a query that displays all the returns for the car make Toyota.

21; 22; 23 2022

© The Independent Institute of Education (Pty) Ltd 2022

Page 11 of 14

8. Write a query that counts the number of rentals that were placed for the car make

Hyundai.

9. Write a query to update the Model of the car with the CarNo FOR001 from “Fiesta” to

“Focus”.

10. Write a query that will display the CarNo, Driver Name, Rental Fee, Start Date, End Date

and Availability of all available rentals.

11. Write a query that will show a list of the available car makes in the database use the

DISTINCT command.



1
Expert's answer
2022-06-09T18:20:57-0400

5.select * from rentals_placed where dates between '2021-08-01' AND '2021-10-30';

6.select * from rentals_placed where placed='Bud Barnes';

7.select * from car where returns=true and make='Toyota';

8.select count(CarNo),model from car where rentals=true and  make='Hyundai';

9.update car set model='Focus'  where CarNo='FOR001' and model='Fiesta';

10.select c.CarNo, c.Driver_Name, c.Rental_Fee, c.Start_Date, c.End_Date,r.name from car c,rentals r

where c.CarNo=r.CarNo;

11.SELECT DISTINCT makes FROM car;


Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS