Page 1 of 1

2. Update the record for CustomerID = 48, ContactName = Henry Hines, City = Reeds 3. Add this new record to the cust

Posted: Sun May 15, 2022 11:44 am
by answerhappygod
2. Update the record
for CustomerID = 48, ContactName = Henry Hines, City = Reeds
3. Add this new
record to the customers table:
Food King, Jennifer Brown, 33 Main Street, Bethel, 06801, USA
4. From the Orders table, show all order
information where customerid is 14 and shipperid is 2;
5. Show the largest
quantity ordered in the OrderDetails table.
6. Using the
Customers table, how many customers do we have? HINT: use the
CustomerID
7. Select all from
the customers table, but show only the ContactName that begin with
M and ends with N