Question: (01) You are working with a DBMS that has two tables Auto and Customer. The tables and contents are: Auto table contains vin# (primary key),
(01) You are working with a DBMS that has two tables Auto and Customer. The tables and contents are:
- Auto table contains vin# (primary key), make (text), color (text), mileage (number)
- Customer table contains customer# (number), name (text), address (text) and telephone# (number)
You want to print a report that lists the the mileage and make of all Honda with under 50,000 miles. Which of the following is the correct Where statement?
Select one:
a.
Where model=honda and mileage<50000
b.
Where model="honda" and mileage<50000
c.
Where model=honda and mileage<"50000"
d.
Where model="honda" and mileage<"50000"
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
