Homework Questions? Ask a Tutor for Answers ASAP
yes, I am having difficulting sending the table image
Is that it? usally they have more lines involved. example
SELECT o.ORDER_NUMBER, o.ORDER_DATE, c.CUSTOMER_NUMBER, LAST AS “LAST NAME” , FIRST AS “FIRST NAME” FROM ORDERS o natural join CUSTOMER c;
SELECT p.PART_NUMBER as “Part Number”, p.PART_DESCRIPTION as “Part Description”,p.UNITS_ON_HAND as “Units on Hand”FROM PART pWHERE p.UNITS_ON_HAND > (SELECT AVG(UNITS_ON_HAND) FROM PART) ;
How long is my window to rate you?
Okay Thank you.