Sopheon interview question

Write some examples of SQL statements: joins, inserts, deletes