Aircraft_Models Airlines Fleet MID manufacturer model сараcity AID AID MID count name Вoeing Вoeing Воoeing 1 777 340 1 AA 1 3 15 787 260 2 UAL 1 2 10 3 737 140 3 DAL 2 2 14 4 Airbus 320 230 4 SWA 3 1...


Write an SQL query to find the manufacturer and model for all aircraft models with capacity at least 300.


Aircraft_Models<br>Airlines<br>Fleet<br>MID<br>manufacturer model<br>сараcity<br>AID<br>AID<br>MID<br>count<br>name<br>Вoeing<br>Вoeing<br>Воoeing<br>1<br>777<br>340<br>1<br>AA<br>1<br>3<br>15<br>787<br>260<br>2<br>UAL<br>1<br>2<br>10<br>3<br>737<br>140<br>3<br>DAL<br>2<br>2<br>14<br>4<br>Airbus<br>320<br>230<br>4<br>SWA<br>3<br>1<br>8.<br>5<br>Airbus<br>380<br>560<br>5<br>ASA<br>3<br>24<br>6<br>Вoeing<br>747<br>420<br>4<br>3<br>7<br>3<br>16<br>

Extracted text: Aircraft_Models Airlines Fleet MID manufacturer model сараcity AID AID MID count name Вoeing Вoeing Воoeing 1 777 340 1 AA 1 3 15 787 260 2 UAL 1 2 10 3 737 140 3 DAL 2 2 14 4 Airbus 320 230 4 SWA 3 1 8. 5 Airbus 380 560 5 ASA 3 24 6 Вoeing 747 420 4 3 7 3 16

Jun 09, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?