Write a SQL query to show all columns from AIRPLANES and PLA…
Write a SQL query to show all columns from AIRPLANES and PLANE INVENTORY Requirements: Must show all airplanes and only related records from plane inventory, for which the model begins with 7 and containts X; variant include ext; minseats is at least 30 and maxseats is at least 50 but no more than 100.