Infosys Interview Question

joins in sql and queries based on it?