Login or Create an Account to view the mark scheme, comment, and add to a test
DriEv, an Electric Vehicle (EV) rental company, is building an electronic database to manage its EV fleet of electric cars and bikes. DriEv’s electronic database design includes the following schema:
tbl_vehicles(vehicle_id, year, brand, model, type)
tbl_rentals(vehicle_id, start_date, days_rented, daily_rate, customer_id)
tbl_customers(customer_id, last_name, first_name, email)
Alaister, a manger at DriEv, would like to know how many unique customers in total have rented a Tesla vehicle since the company was founded. Create a query to fulfil Alaister’s request for information.
[5]
Short Answer5 MarksPremium
4 Uses12 Views2 Likes