1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Vaselesa [24]
2 years ago
15

Required: a. How many customer records are stored in the database? b. List customers who live in New York. c. List customers wit

h credit limits greater than $50,000. d. List sales transactions made in July, 2018. e. What’s the number of total sales transactions made to each customer?
Business
1 answer:
Feliz [49]2 years ago
5 0

Answer:

a- How many customer records are stored in the database

SQL Command for knowing number of customer records are stored is

SELECT COUNT(Customer Name) FROM tbl Customer ;

b- List customers who live in New york.

SQL Command for knowing number of customers who live in New york

SELECT Customer State, FROM tbl Customer WHERE CITY = 'New york' ;

c- List customers who credit limits grater than $50,000.

SQL Command for knowing number of customers who's credit limit is grater than $50,000

SELECT Customer Credit Limit, FROM tbl Customer WHERE Credit limit > 50,000 ;

d. List sales transaction made in July - 18

SQL Command for knowing sales in July - 18

SELECT InvoiceDate, FROM tbl Sales ;

e. What the number of total sales transactions made to each customer

You might be interested in
HELP me please
lara31 [8.8K]
Brainly can solve anything
4 0
3 years ago
The stockholders’ equity accounts of Indigo Corporation on January 1, 2017, were as follows.
Lubov Fominskaja [6]

Answer:

Indigo Corporation

Journal Entries:

Feb. 1:

Debit Cash Account with $60,000

Credit Common Stock with $40,000

Credit Additional Paid-in Capital with $20,000

To record the issue of 10,000 shares of common stock, par $4 at $6 each.

March 20:

Debit Treasury Stock with $8,000

Debit Additional Paid-in Capital with $6,000

Credit Cash Account with $14,000

To record the repurchase of 2,000 shares of treasury stock at $7 each.

October 1:

Debit Dividends - Preferred Stock with $35,000

Credit Dividends Payable with $35,000

To record preferred stock dividends declared.

November 1:

Debit Dividends Payable with $35,000

Credit Cash Account with $35,000

To record cash payment of dividends.

December 1:

Debit Dividends - Common Stock with $249,000

Credit Dividends Payable with $249,000

To record $0.50 per share common stock dividend.

December 31:

Debit Dividends Payable with $249,000

Credit Cash Account with $249,000

To record payment of dividend.

Debit Net Income with $550,000

Credit Retained Earnings with $550,000

To record the transfer of net income to Retained Earnings.

Explanation:

a) Whereas $60,000 cash was received for the issue, only $40,000 (10,000 x $4) is credited to Common Stock.  The additional of $20,000 is credited to Additional Paid-in Capital.  This shows that the shares were issued above their par value.

b) When 2,000 shares of treasury stock were reacquired at a total cost of $7 per share, the Treasury Stock account is debited with the par value of $4 per share ($8,000).  The above par value difference is taken to the Additional Paid-in Capital account as a debit.

c) Dividends on preferred stock was prorated for 10 months, from January to October.  This is because the percentage dividend is for a year.

d) Dividends on common stock would not be prorated since they are based on annual percentages like preferred stock.  Dividends on the common stock is, therefore, calculable on the outstanding balance.  

e) Treasury Stock is a contra account to the Common Stock as it reduces the balance of common stock outstanding.  The outstanding balance of Treasury Stock increased to 12,000 (10,000 + 2,000).

f) Outstanding common stock reduced from 500,000 shares to 498,000 (500,000 + 10,000 - 12,000).  The additional 10,000 represented the new issue and the 12,000 represented the Treasury Stock.

5 0
2 years ago
Suppose that the market equilibrium price for a good is $3.00. A nonbinding price ceiling in this market will result in a price
Nina [5.8K]

Answer:

above $3.00

Explanation:

A price ceiling is when the government or an agency of the government sets the maximum price for a good or service. A price ceiling is non binding if it set above equilibrium price. So price above $3 is non binding. A non binding price ceiling has no effect on the market price.

Price ceiling is binding if it is set below equilibrium price.

Equilibrium price is where the demand and supply curve intersects.

I hope my answer helps you

4 0
3 years ago
Read 2 more answers
What are the four requirement of valid contract
timurjin [86]

Four requirements for a valid contract are an offer, acceptance by the other party of the offer, a mutual agreement or meeting of the minds of the contracting parties and a valid consideration.

3 0
3 years ago
What are the benefits of using a credit card? What are the drawbacks of using a credit card?
Anon25 [30]
Benefits: You do not have to carry large amounts of cash with you


drawbacks: You have to pay interest rates
it is technically a loan


hope this helps
6 0
3 years ago
Read 2 more answers
Other questions:
  • Spade and Marcher Corp. manufactures and sells toy guns. These toy guns are a perfect imitation of real weapons. Inspired by Spa
    12·1 answer
  • G during february, $186,500 was paid to creditors on account, and purchases on account were $201,400. assuming the february 28 b
    13·1 answer
  • Cost estimates on a long-term contract may indicate that a loss will result on completion of the entire contract. In this case,
    11·2 answers
  • Bailey, a single taxpayer, obtains permission to change from a calendar year to a fiscal year ending June 30, 2019. During the s
    10·1 answer
  • Ingraham Inc. currently has $320,000 in accounts receivable, and its days sales outstanding (DSO) is 63 days. It wants to reduce
    7·1 answer
  • Even if you are willing to take on more responsibility, you need to make sure that ______. a. you do not take on too much b. you
    7·2 answers
  • On February 1, a customer's account balance of $2,700 was deemed to be uncollectible. What entry should be recorded on February
    11·1 answer
  • Fabio corporation is considering eliminating a department that has a contribution margin of $26,000 and $74,000 in fixed costs.
    11·1 answer
  • The Blending Department of Luongo Company has the following cost and production data for the month of April.
    10·1 answer
  • A core aspect of marketing involves a(n) , which is a transaction in which things of value are traded by buyers and sellers.
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!