Infor Interview Question

SQL, Basic questions over DML, JOIN and subqueries?