Emma (UK) interview question

Simple join using SQL between 2 tables