Homework 6.docx - Module/Week 6(Chapter 4 Instructions...

This preview shows page 1 - 2 out of 4 pages.

Module/Week 6: (Chapter 4)Instructions: Write the SQL code to perform the tasks requested in each problem. Screenshots arerequired for each SQL statement for a grade to be given.Part I: Problems 1–11, 18 (pages 123–124); 1 point each1.List the customer number, the name (first and last), and the balance of customers.
2.List the customer number, the name (first and last), and the balance of customers who reside in Colorado (Cust- State is CO).
3.List all columns of the Product table for products costing more than $50. Order the result by product manufacturer (ProdMfg) and product name.
4.List the order number, order date, and shipping name (OrdName) of orders sent to addresses in Denver or Englewood.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture