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
(a).
tbl_vehicles.vehicle_id = *
(b).
tbl_vehicles = tbl_rentals
(c).
tbl_vehicles.vehicle_id = tbl_rentals.customer_id
(d).
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