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.
In order to fulfil Alaister’s request for information, what statement should replace "X" in the following query:
SELECT COUNT(DISTINCT customer_id) FROM tbl_vehicles, tbl_rentals, tbl_customers WHERE tbl_vehicles.brand = “Tesla” AND X AND tbl_customers.customer_id = tbl_rentals.customer_id
tbl_vehicles.vehicle_id = *
tbl_vehicles = tbl_rentals
tbl_vehicles.vehicle_id = tbl_rentals.customer_id
tbl_vehicles.vehicle_id = tbl_rentals.vehicle_id

Multiple Choice1 MarkPremium
6 Uses10 Views2 Likes
Login or Create an Account to view the mark scheme, comment, and add to a test