Write a query using a join to display the passng_id, first_name, last_name, ticket_id, and no. of seats of all records in passenger table joined with tickt table.