Morgan Stanley interview question

SQL statements and what they do, and write a simple SQL query