Determine columns that make up the primary key
Q1) Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.
All questions should be answered with one SQL statement. Use the new Join syntax.
1. Find the columns that make up the primary key of the l_lunch_items table. Sort the columns by position. (Do this in one statement).
2. List all the lunches that employees have signed up for. Show me first_name, last_name, lunch_date, and product_code of the items they ordered. Do not include employees who don’t have a manager.
Sort the rows by product_code.
3. From the employees table, list the employee_id, last_name, and phone_number of every employee, along with the last_name and phone number of his manager. Sort the rows by employee_id. (Hint…tables can be joined to themselves…just give each table a different alias).
4. Similar to 3, but include rows for the people who do not have managers.
5. Count the number of foods supplied by each supplier. List all the suppliers. Show the supplier_id, supplier_name, and number of foods from each supplier. Sort the rows on the supplier_id.
6. Count the number of employees who work in each department. List all the departments. Show the department code, department name, and the number of employees. Sort on the dept_code.
