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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

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

Post 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply