I\'m behind in my SQL homework I need major help from the great people at cramst

Question

I'm behind in my SQL homework I need major help from the great people at cramster.



Note: Question 14 has been answered

Directions
Perform the tasks below by using the correct SQL statements. You must 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 the assignment document. Upload this Word document for grading.
Scenario:
The suppliers want access to our database to enter their own prices. Although they are worried that other suppliers can see their prices, we have assured them that this is not possible.

Review questions


11. List the employees hired before 2002. Show the employee_id, first_name, last_name, and hire_date columns. Bring the last_name and first_name back in last_name, first_name format. Call this column full name. Sort the rows by employer_id.


12. From the l_foods table, list the description and price values of the following foods: hamburger, french fries, and soda. Sort the rows by description.

13. From the l_foods table, list the foods that have “fresh” in their descriptions. Sort these rows in ascending order.

14. List the employees who have a manager. Show the employee_id , first_name, and last_name. Sort the rows by employee_id.

Explanation / Answer

12.SQL> seelect description,price from l_foods where description='hamburger', 'french fries','soda' order by description; 13.SQL> select * from l_foods where description like 'fresh';

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.