Display the balance of the customer

Assignment Help Database Management System

Reference no: EM13812920

Part A:

1. Display the id, the description, and the total value (product quantity * product price) of each product whose product type is HW. Assign the column name TOTAL_VALUE to this calculation.

2. Display the id, the description, and the total value (product quantity * product price) of each product whose total value is greater than or equal to $4,000. Assign the column name TOTAL_VALUE to the calculation.

3. Display the id and the description for each product whose type is either SG or AP using the IN operator.

4. Determine the id and the name of each customer whose name starts with the letter "S".

Part B:

5. Display all the data in the products table. Order the display by the product description.

6. Display all the data in the products table. Order the display by product type. Within each product type, order the display by product id.

7. Determine the number of customers whose balances are less than their credit limits.

8. Display the total of the balances of all customers who are represented by sales representative 237 and whose balances are less than their credit limits.

9. Display the id, the description, and the total value of each product whose number of items is greater than the average number of items for all products. You may want to use a subquery.

10. Display the balance of the customer whose balance is the smallest.

11. Display the id, the name, and the balance of the customer with the largest balance.

12. Display the sales representative's id and the sum of the balances of all customers represented by each of these sales representatives. Group and order the display by the sales representative ids.

13. Display the sales representative's id and the sum of the balances of all customers represented by each of these sales representatives, but limit the result to those sales representatives whose sum is more than $12,000.

14. Display the ids of all products whose description is not known.

Reference no: EM13812920

Questions Cloud

How you determined the types of accommodations needed : Elaborate on how you determined the types of accommodations/modifications needed throughout your lesson activities and assessments.

The president with the best character is the : The President who lacks enthusiasm, but otherwise seeks his countrymen's love and might rise to the occasion is

Describe how e-commerce begin and what made it successful : Describe how e-commerce begin and what made it successful. As a member of an IT staff, how can you use social media to support e-commerce? You can search business websites to find good practices of using social media in e-commerce

Ethics-social responsibility in developing strategic plan : Explain the role of ethics and social responsibility in developing a strategic plan while considering stakeholder needs and agendas.

Display the balance of the customer : Display the balance of the customer whose balance is the smallest. Display the id, the name, and the balance of the customer with the largest balance

Major process flow structure : Which of the following is considered a major process flow structure? ISO audits result in certifications that are done by first, second, or third parties. Which of the following result in the best certification of a firm?

Hard logic and soft logic for establishing dependency : 1. In your own words, explain the difference between hard logic and soft logic for establishing dependency relationships in project schedules. Offer a creative example (not from the chapter) of each one.2. Explain the relationships among project deli..

What is the functional equivalent of the border : What is the functional equivalent of the border

Test the null hypothesis that the population standard deviat : In a sample of n = 15 selected from an underlying normal distribution, we obtain standard deviation s =10. Test the null hypothesis that the population standard deviation σ = 16.

User Account

All Pages