Consider The Following Tables Which Are A Part Of A Car Rental Database Table Name Car Registration Num Abu 2522 Aba 1 1 (40.36 KiB) Viewed 37 times
Consider The Following Tables Which Are A Part Of A Car Rental Database Table Name Car Registration Num Abu 2522 Aba 1 2 (24.29 KiB) Viewed 37 times
Consider the following tables which are a part of a car rental database: Table Name: CAR Registration Num ABU 2522 ABA 1978 WKC 6256 AEM 7778 BDO 8787 WJH 3465 Table Name: RENTAL 122 Make Model Year OfManufacture Hyundai Elantra Honda City Perodua Kancil Perodua Kenari Hyundai Sonata Hyundai Sonata 123 133 145 146 177 RecID Registration Num CustCode MilesDriven DateHired 100 ABU 2522 E100 2300 2018-02-05 ABA 1978 1200 WKC 6256 100 AEM 7778 550 BDQ 8787 50 ABU 2522 900 WKC 6256 700 2013 C100 K201 K202 S105 S105 E100 2016 2017 2016 2015 2014 2018-02-06 2018-02-07 2018-02-08 2018-02-10 2018-02-12 2018-02-24 Time left 0:56:42 Need Help?
Table Name: CUSTOMER CustCode CustName E100 S.J.Salim C100 Harish K201 Su Chin K202 Mohd Salleh S101 S105 Ramakrishna John Brown A▾ Location Selangor Perak Kuala Lumpur Selangor Perak Kelantan Based on the tables above, write SQL statements for the following queries: Time left 0:56:31 List the customers who rented a car which 'make and model' is 'Honda City' BI
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!