northwind

docx

School

University of Delaware *

*We aren’t endorsed by this school

Course

604

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by CaptainMetal12072

Northwind database. Its structure is listed below:  List all orders that were shipped by Speedy Express (this might require two queries): 54 rows returned

 List all order id's and dates for orders that were not entered by an employee (note: make sure you review the Chappell book to understand how to use <null> in a query). 3 rows returned  List all orders placed by Anne Dodsworth 6 rows returned  List product id's, names, unit, and price for all Meat/Poultry items 6 rows returned List all order detail rows that contain Boston Crab Meat. Include the order id and quantity. 8 rows returned  List all customers from the United States. 13 rows returned Queries: use Northwind; select * from Orders where ShipperID=1; select OrderID,OrderDate from Orders where EmployeeID is null; select OrderID,OrderDate from Orders where EmployeeID=9; select ProductID,ProductName,Unit,Price from Products where CategoryID=6;

select OrderDetailID,OrderID,Quantity from OrderDetails where ProductID=40; select * from Customers where Country='USA';

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

northwind

Related Documents