ProtoTech Solutions interview question

SQL Queries especially join query.