Sopheon interview question

Write some SQL statements (Insert, Select, Join)