Get the full details of the promotions with a budget greater than $100,000. Get the employee number and promotion number for employees with unknown (NULL) jobs who work on promotion P2. Using a subquery, get full details of all the employees whose stores

Get the full details of the promotions with a budget greater than $100,000. Get the employee number and promotion number for employees with unknown (NULL) jobs who work on promotion P2.
Using a subquery, get full details of all the employees whose stores are located in Orlando. Detach the database and create a zip file called ITCO630_P1.ZIP including the associated log file and the query file. After creating the zip file, reattach the database.