My SQL workbench DB: Northwind 6. List of Products whose listprice between 15 an

Question

My SQL workbench

DB: Northwind 6. List of Products whose listprice between 15 and 20 sort by category 7. Display the shipping address (address, city, state, zip) of Sales Representative (Table Hint: Employees, Orders) 8. Display list of Product Names along with 'WhenToOrder' based on following condition. If difference between TargetLevel and ReorderLevel is greater than 50 units display WhenToOrder as 'After 50 Days' If difference between TargetLevel and ReorderLevel is greater than 30 units display WhenToOrder as 'After 30 Days' If difference between Targetlevel and ReorderLevel is greater than 20 units display WhenToOrder as 'After 20 Days' If difference between TargetLevel and ReorderLevel is less than 20 units display WhenToOrder as 'Order now 9.Display Orders which has New status. (Hint: Orders and Order_status table) 10.Display unique categories in Products table 11. Display customer details sorted by job title in following order Owner Purchasing Manager Accounting Manager Purchasing Representative Purchasing Assistant Accounting Assistant 12. In orders table display Order date in place of Shipped date when shipped date is not available 13. display orders which took more than 2 days to get shipped. (Hint: date function discussed in lab) 14. Query to find total orders. 15. What is Flat, hierarchical & Network database model ? What is their advantages and disadvantages ?

Explanation / Answer

In roder to provide the correct SQL queries, you would need to provide me the DB schema details and the tables' structure.

Since you have not provided any such details, I am guessing the table names and column names and providing you the SQL queries. In case of any issue, kindly reach out to me.

6. SELECT * FROM Products WHERE list_price BETWEEN 15 AND 20 ORDER BY category;

7. SELECT o.address, o.city, o.state, o.zip FROM Employees e, Orders o WHERE e.order_id = o.order_id AND e.type = 'Sales Representative';

8.

a) SELECT name, 'After 50 Days' AS 'WhenToOrder' FROM Product where (TargetLevel - RecordLevel) > 50;

b) SELECT name, 'After 30 Days' AS 'WhenToOrder' FROM Product where (TargetLevel - RecordLevel) > 30;

c) SELECT name, 'After 20 Days' AS 'WhenToOrder' FROM Product where (TargetLevel - RecordLevel) > 20;

d) SELECT name, 'Order Now' AS 'WhenToOrder' FROM Product where (TargetLevel - RecordLevel) < 20;

9. SELECT * FROM Orders o, Order_status os WHERE o.order_id = os.order_id AND os.status = 'New';

NOTE: As per Chegg policy, I am allowed to answer only 4 questions on a single post. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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