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.




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.

Explanation / Answer

11.SQL> select employee_id,last_name,first_name,hire_date from l_employees where hire_date < 01-Jan-2002;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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