Write a query to list all fields and records from the product table. Do not list out
Question:
Write a query to list all fields and records from the product table. Do not list out the individual fields in the select portion of your query.
Write a query to list the customer name and credit limit of customers who live outside of the US and have a credit limit of less than $10000.
Write a query to list the product id, product description and inventory value (number in inventory X wholesale price) for all products in the database. Name the new calculated field US_VALUE and sort the record in ascending order by product id.
Write a query that gives the number of customers who owe more than their credit limit allows. Label the field as LIMIT_OVER in your output.
Write a query that gives the total amount owed by all the customers represented by each sales rep. The output should be grouped by sales rep. The output should be grouped by the sales rep. Label the total amount field as OWED_TOTAL.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi