Infosys interview question

joins in sql and queries based on it?