Using your ERD, Which SQL code might you write to find out the total number of FlashTaxi vehicles in Dubai.

Choose the best option

A) Select sum(Vehicle_ID)

From City, Vehicle

Where Vehicle.City_of_registration=City.City_Name

and

City.City_Name="Dubai";

B)Select count(Vehicle_ID)

From City, Vehicle

Where City.City_Name="Dubai";

C)Select count(Vehicle_ID)

From City, Vehicle

Where Vehicle.City_of_registration=City.City_Name

and

City.City_Name="Dubai";

Select sum(Distinct Vehicle_ID)

From City, Vehicle

D)Where Vehicle.City_of_registration=City.City_Name

and

City.City_Name="Dubai";