Question: Write a SQL statement that will return a distinct list of carriers, in alphabetical order, for all airlines that fly aircraft manufactured by Boeing. Do

Write a SQL statement that will return a distinct list of carriers, in alphabetical order, for all airlines that fly aircraft manufactured by Boeing. Do not use any joins in this SQL statement.

Help, I don't think I'm doing this correctly using subquery.

--first query

SELECT DISTINCT (AirlineName) FROM Airlines --ORDER BY AirlineName WHERE AirlineName IN (SELECT Manufacturer FROM Planes WHERE Manufacturer = 'Boeing');

--second query

SELECT DISTINCT(AirlineName) FROM Airlines SELECT PlaneID FROM Planes WHERE Manufacturer = 'Boeing';

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 Databases Questions!