Synechron interview question

How to use joins, clauses, various database functions in sql and write queries for the same