NORTHWIND SQL QUESTION(I WAS GIVEN 32 QUESTIONS TO DO UNABLE TO SOLVE 2 PLEASE HELP)

Find the distinct shippers who are to ship the orders placed by employees with IDs 1, 3, 5, 7 --Show the shipper's name as "Express Speedy" if the shipper's ID is 2 and "United Package" if the shipper's --ID is 3 and "Shipping Federal" if the shipper's ID is 1

2.1. Which orders took the least number and maximum number of shipping days? Get the orderid, employees full name, number of products, number of days taken to ship the product and shipper company name. Use 1 and 2 in the final result set to distinguish the 2 orders.(SHOULD BE DONE USING UNION)

HERE's THE SCHEMA



Read more here: https://stackoverflow.com/questions/67931309/northwind-sql-questioni-was-given-32-questions-to-do-unable-to-solve-2-please-h

Content Attribution

This content was originally published by Kishore Kunal at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: