/* Query 7: list bookings and number of passengers with 2 or more passengers together
Write your query and store the result in table bookings_passenger.
*/

DROP TABLE bookings_passenger;
CREATE TABLE bookings_passenger(
    book_ref character(6),
    passengers int
); 


/* 
Your code here
*/