Create the following queries on the ITD640_B database used for IP3 and save them all in a file called ITD640_P5.SQL. Remember that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. Also remember to define what database to use with a USE statement.
1. Using a join, get the full details of all the employees who are working on the Harvest Ball promotion.
2. Get the promotion names (duplicates eliminated) being worked on by employees from the Rocky Mountain Produce store.
3. Get the last names of all the employees who are working on promotion P1.
4. Get the employee numbers and start dates of all the employees with start dates equal to the earliest date.
5. Insert yourself in the employee table using the last five digits of your phone number as the employee number and show yourself as working for Rocky Mountain Produce. Then show all the records in the employee table.
6. Delete yourself from the employee table by matching your employee number, and then show all of the records in the employee table.