Please complete all parts.

7. Show the structure of the EMP table. Create a query to display the name, job. hire date, and employee number for each employee, with employee number appearing first. 14 rows selected. 9. Create a query to display unique jobs from the EMP table