Passengers with Hotmail email addresses

Partnership marketing wants to reach Hotmail users for a themed integration campaign. Return the full record for every passenger whose email is in the hotmail.com domain.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

idagecitynameemail
235NaplesLiamliam@hotmail.com
440HamburgNoahnoah@hotmail.com

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid