Accenture interview question

SQL joins , primary key, unique keys, subqueries