/* Query 3: list number of seats available per aircraft 
Write your query and store the result in table seats_aircraft.
*/

DROP TABLE seats_aircraft;
CREATE TABLE seats_aircraft(
    aircraft_code character(3), 
    seats int
); 


/* 
Your code here
*/