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. Your answer must use the same column names as this sample — alias them with AS if needed.

id	name	email	age	city
2	Liam	liam@hotmail.com	35	Naples
4	Noah	noah@hotmail.com	40	Hamburg

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid