KORE Software interview question

SQL two tables join query.