Write a query using JOINS to list the orderid, partid, and part description and units on hand or every order that has not shipped.

SalesRep Customer PK ReplD int varchar(20) varchar(20) PK CustomerlD int O--OLastName FirstName CommissionRate decimal(10,2) LastName varchar(20) FirstName varchar(20) Street City State Zipcode char(5) Balance decimal( 10,2) varchar(20) varchar(20) char(2) Order FK1 ReplD int FK1 CustomerlD int OrderDat date ShipDate date Part PK PartID int OrderLine Description varchar(20) UnitsOnHand int ItemClass char(4) Retail Cost PK,FK1 OrderlD int decimal (10,2) decimal (10,2) Quantityint