Question: For each postal code, how many customers are there, and its total_balance? Report Postal_Code, Num_of_Customers, T_Balance REP ( REP_NUM , LAST_NAME, FIRST_NAME, STREET, CITY, STATE,

For each postal code, how many customers are there, and its total_balance?

Report Postal_Code, Num_of_Customers, T_Balance

REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMMISSION, RATE)

CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM)

ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM)

ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE)

ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)

 


Step by Step Solution

★★★★★

3.41 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SELECT POSTALCODEcount as NumofCustomerssumBALANCE as TBalance from CU... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

A marketer is interested in how many customers are likely to buy a particular product in a particular store. Let P be the proportion of all customers in the store who will buy the product. Let the...

Q:

ITEM NO. QTY UNIT DESCRIPTION UNIT PRICE TOTAL 1 1 PCS UMBRELLA RACK STAND ORGANIZER 4,375.00 4,375.00 2 1 PCS TOWEL RACK 450.00 450.00 3 17 PCS SPRAY BOTTLE (MEDIUM) 30.00 510.00 ***NOTHING...

Q:

How many 5-letter code words are possible from the first 7 letters of the alphabet if no letter is repeated? If letters can be repeated? If adjacent letters must be different?

Q:

Write a paper about Business Brief for the Company Executive team on your findings. The company is kroger read how to do a business brief: smallbusiness.chron.com/write-business-brief-3126.html...

Q:

A hydraulic lift is used to jack a 970-kgcar 12cm off the floor. The diameter of the output piston is 18cm, and the input force is 250N. (a) What is the area of the input piston? (b) What is the work...

Q:

The Ferguson Paper Company produces rolls of paper for use in adding machines, desk calculators, and cash registers. The rolls, which are 200 feet long, are produced in widths of 11/2, 21/2, and 31/2...

Q:

The market for apple pies in the city of Ectenia is competitive and has the following demand schedule: Price Quantity Demanded $1.............. 1,200 pies 2.............. 1,100 3.............. 1,000...

Q:

Required Access the CICA Handbook and locate the following: (a) What number is the CAS for audit documentation? (b) How many sections are there to each CAS? (c) What is the name of Section 5025? (d)...

Q:

An experiment was conducted to investigate the effect of management training on the decision-making abilities of supervisors in a large corporation. Sixteen supervisors were selected, and eight were...

Q:

Consider a fixed partitioning scheme with equal-size partitions of 216 bytes and a total main memory size of 224 bytes. A process table is maintained that includes a pointer to a partition for each...

Q:

At the annual strategic planning retreat, you have been tasked to identify processes and objectives related to building the organization's non-financial performance measures, such as customer...

Q:

ToFrom Trucking serves two segments of customers. One segment (A) is willing to pay $3.50 per cubic foot but wants to commit to a shipment with only 24 hours' notice. The other segment (B) is willing...

Q:

(a) Let Z be a standard normal. Find Pr(-1.96 3). (c) Let X be a t-distribution with df=10. Estimate Pr(-2.2 X*)=.05? (e) Let X be a F10,00 distribution. What value X* solves Pr(X>X*)=.05?

Q:

Time: 75 minutes Problem 1 (2 points) Calculate I = fc(1+ y)dl, where C is the under half of the circle 2+ y = 4.

Q:

Build a LP model for the following scenario, but don't solve the LP model that you made. A company manufactures two products whose unit profits are $17 and $15, respectively. The company has budgeted...

Q:

What is the intercept for the regression equation to forecast demand, in the worksheet: Food Truck Demand?

Q:

Kirsten believes her company's overhead costs are driven (affected by the number of direct labor hours because the production process is very labor intensive. During the period, the company produced...

Q:

Identify the source of funds within Micro Credit? How does this differ from traditional sources of financing? What internal and external governance mechanisms are in place in Micro Credit?

Q:

Schedule variance (SV) is in dollars and does not directly represent time. Why is it still useful?

Q:

The CyClon project team has started gathering information necessary to develop a project network-predecessor activities and activity time in days. The results of their meeting are found in the...

Q:

The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects. Below are three projects under consideration. a. Using the scoring matrix below, which project would...

Q:

3. What makes you happy? Do you think that at different times of your life, different things made you happy? Do you think that your happiness relates to better physical health? Or do you think better...

Q:

3. When you are in another culture and do not speak the language, how do you communicate?

Q:

1. Take the figure of the fish (Figure 5.5) and show it to people from different cultures for ten seconds, and then ask them to recall as many things in the picture as possible. Would you replicate...