Write SQL statements for each task:(i) To list the details of equipment (equipment code, name, description, rental rate per day) that cost above $10 to rent per day, with an equipment code that starts with ‘CAM’ and the equipment has been loaned to a customer who is at least 30 years old this year. Give the result in ascending order of the equipment name and rental rate per day. Use subquery. EquipmentCode NameDescriptionRentalRatePerDayCAMO2Tent 4 Persons 4-Person Tent 18.002CAMO3Tent 6 Persons 6-Person Tent 22.00 (a)Refer to Figure Q3(a)(i) for the data model for equipment loans.CustomerEquipmentLoanidequipmentCodenameidnameequipmentCode >eaddressdescriptioncontactstartDateRentalRatePerDaydateOfBirthreturnDateoccupationDamageReportreportIddamageType

1. The query for the first part is as follows: Select e.equipmentCode AND e.name AND e.description…

Answered: Write SQL statements for each task:

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Write SQL statements for each task:
(i) To list the details of equipment (equipment code, name, description, rental rate
per day) that cost above $10 to rent per day, with an equipment code that starts
with ‘CAM’ and the equipment has been loaned to a customer who is at least
30 years old this year. Give the result in ascending order of the equipment name
and rental rate per day. Use subquery.