KORE Software Interview Question

SQL two tables join query.