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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!