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 Uses5 Views2 Likes
Login or Create an Account to view the mark scheme, comment, and add to a test