Barclays interview question

joins,clauses in sql with example,unix,plsql,