Samyak Software interview question

SQL join queries