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.
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 Uses18 Views2 Likes