. Using the Cash Receipt Table below, write the SQL that show the output of total cash payments from Customer ‘C-2’ (hint: use the sum () function-15% of Grade).

Cash Receipt:

Remittance

Advice#

Amount

Bank

Account#

Date

Customer

Number

Cashier

Number

RA-1

1,666

BA-6

25-JUL-2014

C-2

E-39

RA-2

10,000

BA-7

26-JUL-2014

C-2

E-39

RA-3

72,000

BA-7

15-AUG-2014

C-1

E-39

RA-4

32,600

BA-7

15-AUG-2014

C-5

E-39

RA-5

1,669

BA-6

25-AUG-2014

C-2

E-39

Answers

Answer 1

To calculate the total cash payments from Customer 'C-2' using the given Cash Receipt table, we can write an SQL query that utilizes the SUM() function and filters the rows based on the CustomerNumber

The SQL query to retrieve the total cash payments from Customer 'C-2' would be as follows:

```sql

SELECT SUM(Amount) AS TotalCashPayments

FROM CashReceipt

WHERE CustomerNumber = 'C-2';

```

This query selects the Amount column from the CashReceipt table and calculates the sum using the SUM() function. The WHERE clause filters the rows based on the CustomerNumber, specifically 'C-2'. The result will be the total cash payments made by Customer 'C-2'.

Learn more about SQL queries here: brainly.com/question/30755095

#SPJ11


Related Questions

Based on the W-2 provided, Social Security tax withheld for Lily was ______ of wages and Medicare tax withheld was ______ of wages.

a. 1.3%, 5.5%
b. 6.2%, 1.45%
c. 10%, 10%
d. 28%, 39.8%

Thanks for any help I can get! I don't need an explanation as to how you got the answer. ​

Answers

Answer:

b. 6.2%, 1.45%

Explanation:

Social security and medicare are calculated as a percentage of the gross pay. For Lily, gross pay is $14,450.

For social security, 895.90 is deducted. As a percentage of her gross pay

895.90 will be.

=895.90/ 14,450 x 100

= 0.06193771 x 100

=6.2 %

For medicare, 209.5 has been deducted.  As a percentage of her gross pay, 209.5 is

=209.5/ 14,450 x 100

=0.01449827 x 100

=1.45%

The social security tax is the tax amount that is acquired from the earned income to fund the benefits of social security. It is the major part of the salary that carries the benefits for the person who earns it and contributes some part for the benefits of the government.

The correct answer is b. 6.2%, 1.45%

Social security and medicare are calculated as a percentage of the gross pay. For Lily, gross pay is $14,450.

For social security, 895.90 is deducted. As a percentage of her gross pay

895.90 will be.

[tex]=\frac{895.90}{14,450}\times 100= 0.06193771 \times 100=6.2 \%[/tex]

For medicare, 209.5 has been deducted.  As a percentage of her gross pay, 209.5 is

[tex]=\frac{209.5}{14,450} \times 100=0.01449827 \times 100=1.45\%[/tex]

To know more about the social security tax, refer to the link below:

https://brainly.com/question/14507603

If you have an orientation where you are completing training exercises on a computer, it is probably a ____.
A new hire orientation
B interactive orientation
C reorientation
D mentorship

Answers

Answer: new hire orientation

Explanation:

New employee orientation is used in order to welcome newly employed workers to the organization and this is done in order to integrate the new workers into the system, train them, and make them feel welcomed and part of the organization. .

This helps to boost the confidence of the employees, leads to increase in the retention of employees and also boost employees morale.

Interaction orientation simply means the interaction that takes place between companies and their customers and this is done in order to improve the relationship with customers and achieve organizational goals.

Mentorship simply means having a mentor to guide an individual. Reorientation simply means to change a particular focus or mindset of certain people.

Based on the explanation, the answer is new hire orientation.

Answer:

A

Explanation:

if i post by business page will you guys follow it ?

Answers

Answer:

Yassss queeeennnn

Explanation:

jdnskakana

Explanation:

Yes i will definately follow it

Which is used to trace a check back to the account on which it was written?
Group of answer choices

a valid date

an endorsement

a bank route number

a signature

Answers

Answer:

a bank route number

Explanation:

The routing number is among the three numbers found at the bottom of a check. The routing number is at the bottom left.  It serves as an ' identity ' for your bank. The routing number enables other banks to contact your bank and collect funds from your account every time you write a check.

A routing number is a unique number for every banking institution.  The number proves that the bank is a recognized financial institution with an account with the Federal Reserve.

what is the role of doctors in our society?​

Answers

Their role is to serve the society as others do basically contribution but their actual role is to help others through their medical knowledge.

If 135 TV's are sold and cost $275 to produce and is priced at $250, what is the profit/loss?

Answers

Answer:

$25

Explanation:

The production cost is $275.

The selling price is $250

The loss/profit will be: Selling price minus cost price

=$250 - $275

=  -$25

A loss of $25.

If this is the cost for all the 135 TVs, then the loss is only $25.

N:B

If the costs are for one TV, then the loss will be $25 x 135=$3,375

Jerry's job requires that he wear a suit and tie every day to the office. This is most likely a(n) _____ atmosphere.

Answers

Answer:

I would say a formal or business atmosphere.

Explanation:

The main jobs that require suits are often business atmospheres. However, the wearing of a suit is called formal attire.

Answer:

The answer is formal

Explanation:

I took the quiz and got all of the answers right.

TRUE OR FALSE: It is always free to use an ATM if you have a debit card

Answers

Good luck !!! This is what I found

Answer:

False

Some banks/stores will require you to pay if you use an ATM. In some cases, it is not about whether you have a debit card or not. Debit cards are primarily used to remove money from a bank account, not for ATMs.

What is the difference between Money
Market and Investments?

Answers

Answer:

can udo a pic so i can see

Explanation:

when did Toronto​ pearson​Airport​(Canada) start​ using​ technology​ or​ scanner​

Answers

Answer:

Canada's busiest airport will soon start to use artificial intelligence- powered technology to detect weapons. The technology can detect both metallic and non-metallic weapons ranging from  guns and knives to explosives, according to Liberty Defense Holdings Ltd., a  Vancouver-based company which first marketed the technology.  Known as Hex wave, the technology works by capturing radar images, then using  artificial intelligence to analyze them for concealed weapons in bags or under clothing.   Liberty's CEO, Bill Riker explained, "radar essentially is emitting this form of energy,  it's reflecting off a person and it's identifying any items on a person's body that don't  belong on a body." The technology will start getting deployed at Pearson in the Spring of 2020 in a bid to boost  security, according to the Greater Toronto Airports Authority, which runs Pearson.

WILL GIVE BRAINLIEST
If loans and credit card debt are taking up most of your monthly income, which of the following is the LEAST effective first step in getting your debt under control?
A. Start a side hustle and allocate the money you make towards extra payments for your debt.

B. Take a hard look at your budget and try to cut nonessential items so you have more cash to pay down your debt.

C. Declare bankruptcy, which will eliminate all your debts and allow you to start over with a clean slate.

D. Pay extra money each month to the debt with the highest interest rate, so you'll decrease the total amount you'll spend on debt.

Answers

Answer:

a or c i fliped a coin and got A sounds like the answer rember jesus loves you

Explanation:

Fractional reserve banking increases the money supply in an economy by:
A. preventing depositors from leaving a lot of money in banks.
B. requiring the government to print more money in certain
situations.
C. loaning money that would otherwise be held in a bank.
D. accepting currencies from many different countries to pay off
loans.

Answers

Answer:

C. loaning money that would otherwise be held in a bank.

Explanation:

Fractional reserve banking increases the money supply in an economy by "loaning money that would otherwise be held in a bank."

Fractional reserve banking is known as a system of banking whereby the banks hold a fraction of what customers deposit as reserves. Then the banks use the remaining to give loans and thereby creating and increasing the supply of money. Commercial banks practise this type of banking system. This tells of how commercial banks are affecting the money supply. The bank reserves are usually held as cash in the bank. It can also as balances in the bank's account at their central bank.

Answer:

C. loaning money

Explanation:

just did it on a-p-e-x

Describe the information you will need to provide in order to complete a FAFSA. List at least three of the required documents you must include.

Answers

Answer:

Sample response: To complete a FAFSA, I must first include information to verify my identity. This includes my Social Security number or a driver's license. I must include information about my income or my family's income (if they are still responsible for my care). Finally, I must submit financial information, like my account statements.

Explanation:

2020 edg

To satisfy demands for withdrawals, banks keep:
A. discount rates.
B. monetary policies.
C. balance sheets.
D. fractional reserves.​

Answers

C. balance sheets

explanation:

In what circumstance would a property insurance claim be rejected?

Answers

• You don’t file your claim promptly
• The cause of property damage falls under an exclusion condition in your policy.
•You haven’t been paying your insurance premiums.
• The damage isn’t sufficiently documented
•The insurance adjuster finds anything suspicious or false in the claim.
•You didn’t take precautions to prevent further damage after the initial loss.

Why do you think economists have different belief systems/theories on economics?

Answers

Economists have different belief Systems because Economists also disagree because their methods are not good enough to reveal the whole truth. Economic theory is an attempt to explain and interpret economic data, for example, to determine the causes and effects of economic events.

Answer:The principal disagreement among economists is a matter of economic philosophy. There are two major schools of economic thought: Keynesian economics and free-market, or laissez-faire, economics.

Keynesian economists, named after John Maynard Keynes, who first formulated these ideas into an all-encompassing economic theory in the 1930s, believe that a well-functioning and flourishing economy may be created with a combination of the private sector and government help.

By government help, Keynes meant an active monetary and fiscal policy, which works to control the money supply and adjust Federal Reserve interest rates in accordance with changing economic conditions.

By contrast, the free-market economists advocate a government "hands-off" policy, rejecting the theory that government intervention in the economy is beneficial. Free-market economists—and there are many distinguished advocates of this theory, including Nobel Memorial Prize winner Milton Friedman—prefer to let the marketplace sort out any economic problems. That would mean no government bailouts, no government subsidies of business, no government spending explicitly designed to stimulate the economy, and no other efforts by the government to help what the economists believe is the ability of a free economy to regulate itself.

Explanation:

1. Calculate the Net Worth when Liabilities are $5,000 and Assets are $6,725​

Answers

The answer is 567.879 percent

Which of the following is not one of the factors in determining a pension's final value?

A) Years of serivce
B) Level of education
C) Your age at retirement
D) Your highest salary/pay

Answers

Answer:

B

Explanation:

MULTIPLE CHOICE: Scar stole Mufasa's debit card and used it to buy a vacation package to the Savannah. Which account would the money come out of? (choices are savings, checking, certificate of deposit, and online checking)

Answers

Answer:

Savings.

It cannot come from certificate of deposit or online checking, since it is a debit card.

Think of a substantial product you regularly purchase, such as video games or jeans. If supply is high and
demand is low, what happens to the cost? How might that affect someone's income? Likewise, if supply is low
and demand is high, what happens to the product's cost? How might that affect someone's income?

Answers

Answer:

See below

Explanation:

1. When the supply is high, and demand is low, an item's cost will probably come down. High supply with low demand creates a surplus in the market. Seller will offer the lowest prices possible to woe buyers.

When an item's prices go down, buyers will spend less money buying the product. The buyer saves some money, which is equivalent to having more income than before.

2. With a low supply but high demand, prices tend to go up. There will be great competition for the few goods from the many buyers. As a result, suppliers will hike prices and make more profits.

An increase in prices forces buyers to spend more money to buy the same commodities. Their disposable income decrease, which is the same as having a reduced income

Helppp please
The fact that a country has less strict labor laws and relaxed environmental regulations are strong reasons for a
company to move production facilities to that country.
True
False

Answers

The answer has to be true

Answer:true

Explanation: I just took the test

Virtue ethics places great focus on which of the following

Answers

Answer:

character i think.

Explanation:

Which of the following should which of the following should be of concern when a company considers expanding into a new International market?
the country's legal system
the country's political stability
the education level of the workforce
all of the above

Answers

I think it might be (all of the above)

A _____ is an estimation about a future situation based on the evaluation of facts.

1. projection
2. fact
3. salary
4. growth

Answers

Answer:

Projection

Explanation:

Answer:

Yes the correct answer is (PROJECTION)

Explanation:

A local Barnes and Noble paid a $79.99 net price for each hardbound atlas. The publisher offered a 20% trade discount. What was the publisher’s list price?

Answers

Answer:

i believe it would be 63.99

Explanation:

Based on the information given the publisher’s list price is:$99.99.

Using this formula

List price=Net price/(100%-2=Trade discount)

Where:

Net price=$79.99

Trade discount=20%

Let plug in the formula

List price=$79.99/(100%-20%)

List price =$79.99/80%

List price= $99.99

Inconclusion the publisher’s list price is:$99.99.

Learn more here:https://brainly.com/question/18265503

Should voting be mandatory?

Answers

Answer: Yes

Explanation:

Answer:

no

Explanation:

because no

Which of the following best describes a stock.

A) An incredibly stable investment that is always a safe investment
B) Is insured by the FDIC
C) Represents a share of ownership of a corporation
D) Only sold in the United States

Answers

Answer: C

Explanation: A stock represents a share of ownership of a corporation. Stocks are bought by people so they can get money. If the company's stock they by it from goes well, they get money as well as interest. The answer is C. Hope this helps!

Sam has take-home pay every month of $800. He anticipates that his expenses will add up to $675 for the month. In a zero-based budget, why is it important that she put the extra $125 in SOME budget category? Where might you suggest that Sam put the extra $125?

Answers

Answer:

Second savings account

Explanation:

Life is full of surprises... repairs or emergency cases this would be helpful to have

Answer:

In a zero based budget, your income needs to add up to zero at the end of every month. For that reason I recommend that if he still has money left over after paying bills and other expenses he should put in savings.

Which one of the following businesses would you classify as being in the secondary sector of industry?

A) Oil exploration company
B) Family run farm business
C) Taxi operating business
D) Shoe manufacturer

Answers

Answer:

shoe manufacturer

Explanation:

which of the following is a workplace trend?
A - decreased outsourcing
B - decreased attention to diversity
C- increased use of manual labor
D - increased technology literacy

Answers

Answer:

increased use of manual labor

Explanation:

Advancement in technology has resulted in machines taking over manual jobs.  A few decades ago, manual work was done by human beings exclusively. Industries hired many laborers to assist in many aspects of the business. Today, machines and robots are deployed in different sectors of the economy.

The current trend is the workplace is the use of modern technology. Computers, machines, and robots are gradually replacing people, mostly unskilled and manual laborers.

Other Questions
a) What is the Image Jacobian?b) Derive the Image Jacobianc) Explain its application and usefulness for Visual Servoing Data: RZ=14.5%; rf=2%; and Z=4% 1. Compute the expected rates of return and levels of risk for the Capital Allocation Line (CAL) using values of (i) y=0 (ii) y=0.5 (iii) y=1.0 (iv) y=2.0 BBB, Inc. currently pays no dividends. The firm plans to pay the first dividend of $2.34 at the end of year 3. The dividends are expected to grow at 5% thereafter. Given a requiredreturn of 15%, what would you pay for the stock today?a. $29.33b. $31.38c. $23.60d. $17.70e. None of the above list 3 materials that contain the stored carbon is crucial to connect policy areas of foreign,environmental and economic policies.2. Explain the determinants of policy decisions How long will it take for someone to answer my qs, i posted it two hours ago TB MC Qu. 48 Stevenson Sanitation Corp (SSC) ordered... Stevenson Sanitation Corp (SSC) ordered 1,000 green toilet seats from Commercial Sanitation Supply (CSS). The contract stated "1,000 green toilet seats, FOB SSC loading dock." The toilet seats were required to be green because this was SSC's trademark color. When the shipment arrived, SSC discovered that it has received 1,000 red toilet seats. Before SSC could notify CSS and return the seats, a fire destroyed SSC's building along with the shipment of seats. Which of the following statements is true? Multiple Choice a. This was a destination contract, and since the seats were tendered to the destination, SSC bears risk of loss until they can be returned. b. This was a destination contract, and the tollet seats were nonconforming goods, so CSS did not complete performance and retained risk of loss. c. This was a shipment contract, and SSC assumed risk of loss when CSS delivered the goods to the carrler. d. This was a shipment contract, and CSS retained risk of loss until the goods were tendered to SSC at their loading dock. Micah wants 372 kids to be born on his ranch this year. How many female breeding goats will he need? This is the equation used--> T = 3G ( T= total number of kids born)( Edit- I think this is a 7th or 8th grade level question, probably less than that actually)Thank you :) What is the accurate interpretation of the coefficient on Education? In Salary = 46.7 +0.141 Educ + 0.0336 Exper+ 0.424 Gender + A.For every 1% increase in the Educ, the predicted Salary increases by approximately 14.1%. B.For every additional year of Educ, the predicted Salary increases by approximately $0.141. C. For every 1% increase in the Salary, the expected Educ increases by approximately 14.1%. D. For every additional year of Educ, the predicted Salary increases by approximately 14.1%. Requirement 1. Fred's Flasks, sells flanges for$10.25each. CanGiuseppinasell below Fred's price and still make a profit on the flanges? AssumeGiuseppinaproduces and sells3,000flanges this period.Begin by determining the formula used to calculate the total cost per unit. Choose the correct answer below.A.(Total fixedcosts+Totalvariablecosts)Materialscost perunit=Totalcost per unitB.(Total fixedcosts+Totalvariablecosts)Wagerate perhour=Totalcost per unitC.(Total fixedcosts+Totalvariablecosts)Unitsproduced andsold=Totalcost per unitD.(Materials cost perunit+Wagerate perhour)Unitsproduced andsold=Totalcost per unitPart 2Complete the sentence below. (Round the total cost per unit to two decimal places.)The total cost per unit to manufacture3,000flanges is$enter your response here,therefore, theycancan notmake a profit when compared to Fred's Flasks selling price of$10.25each.Part 3Requirement 2. How would your answer to requirement 1 differ ifGiuseppina'sGlassworks made and sold11,000flanges this period? Why? What does this indicate about the use of unit cost in decision making? (Round the total cost per unit to two decimal places.)The total cost per unit to manufacture11,000flanges would be$enter your response here.Part 4With production and sales at this level, the companycouldcould notpotentially make a profit if the selling price is below$10.25each. Managers must be cautious using unit costs for decision making becausetotal fixed coststotal variable costsdo not change at the unit level. what is the gain on right transferred? 8 years and immediately leased it back for4years The following data pertain to the sale and leaseback transaction: Annual rent 500,000 Sales price4,250,000 Fair value4,500,000 Carrying amount 3,600,000 PV of ordinary annuity of 1 at 10%for 4years3.17 White & Checker is releasing a new power drill that requires the manufacturing of a new part.They are considering whether they should manufacture the part in-house or outsource it from a supplier.The demand forecast is 1,355 units.They calculate the break-even quantity as 1,750 parts.What decision should White & Checker make? A) The product should not be released,as the demand is not high enough. B) A percentage of the product should be manufactured in-house,and the rest should be outsourced. C) The part should be outsourced. D) The part should be manufactured in-house. How would you define and describe the 3-levels, functional, business, and corporate, where strategic decisions are made in an organization? What are the strategic questions that are asked at each level? How do the questions at each level inform and illuminate the decisions at the level below and above each? Provide an example of each strategy decision level for a real-life organization. Draw the Lewis structure for XeCl2 and answer the following questions.How many valence electrons are present in this compound? How many bonding electrons are present in this compound? How many lone pair (non-bonding) electrons are present in this compound? at the most basic level, what is our first experience of an artwork?a. whether it demonstrates a high level of craftsmanshipb. its conceptual message or meaningc. whether it attracts or repels us fill in the profit when the market price is $46Fil in profit when the market price is $46. q 0 1 2 3 4 5 6 7 8 9 10 11 100 150 178 196 212 230 250 272 310 355 410 475 MC . 8882328N933 50 20 14 18 20 45 55 65 R 0 8 The following table presents sales forecasts for Golden GeltGiftware. The unit price is $20. The unit cost of the giftware is$10.YearUnit Sales132,000240,000314,00048, Suppose a person has the utility function U(q1, q2) = - (3/q1) (5/q2). Assume q1 and q2 are positive quantities.a. Find formulas for the marginal utilities MU1 and MU2 .b. Determine whether this utility function satisfies the assumption of monotonicity ("more is better"). Explain your reasoning. [Hint: Determine whether the marginal utilities are positive.]c. Find a formula for the marginal rate of substitution in consumption (MRSC) of good 2 for good 1. [Hint: This is the absolute value of the slope of the indifference curve, when good 1 is on the vertical axis and good 2 is on the horizontal axis.]d. Determine whether this utility function satisfies the assumption of diminishing MRSC. Explain your reasoning. [Hint: According to the formula for the MRSC, does it diminish as q1 decreases and q2 increases?] 6. What happens during the lenders due-diligence period? What is 4/5 is multiply by 9/10