List all columns of the product table for products

This preview shows page 2 - 3 out of 3 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
New Perspectives Microsoft Office 365 & Access 2019 Comprehensive
The document you are viewing contains questions related to this textbook.
Chapter A / Exercise 19
New Perspectives Microsoft Office 365 & Access 2019 Comprehensive
Shellman/Vodnik
Expert Verified
3.List all columns of the Product table for products costing more than $50. Order the result by productmanufacturer (ProdMfg) and product name.
4.List the customer number, the name (first and last), the city, and the balance of customers who reside inDenver with a balance greater than $150 or who reside in Seattle with a balance greater than $300.
5.List the order number, order date, customer number, and customer name (first and last) of ordersplaced in January 2013 sent to Colorado recipients.
6.List the average balance of customers by city. Include only customers residing in Washington state(WA).2
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
New Perspectives Microsoft Office 365 & Access 2019 Comprehensive
The document you are viewing contains questions related to this textbook.
Chapter A / Exercise 19
New Perspectives Microsoft Office 365 & Access 2019 Comprehensive
Shellman/Vodnik
Expert Verified
7.List the average balance and number of customers by city. Only include customers residing in
3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture