SQL - Use statement

Create the following queries and save them all in a file called P1.SQL. Please note that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. Define what database to use with a USE statement.
• Get the full details of the employee table.
• Get the full details of the employees who work in store S2.
• 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 the first and last names of the employees who work in the Orange Appeal store.
• Using a subquery, get full details of all the employees whose stores are located in Orlando

Attached file(s):

sqlquestion.doc  View File