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]
3 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]3 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
You invested in a $5,000 bond in 2012 with a coupon rate of 6%. What will be its value in 2018 if the required rate of return is
ELEN [110]

Answer:

$4540.19

Explanation:

Step 1: Get the formula for the value of the bond  in 2018

Formula= P * (1+r)n

P= Investment = $5000

r= Coupon rate=6%

n= Period or number of years = 6 years

Step 2: Calculate the value of the bond in 2018

Value of the bond in 2018= 5000 * (1+ 0.06)6

= 7092.60

Step 3: Calculate the Present value of the bond

Formula= (P x Present Value Factor) + (Interest x The present value interest factor of an annuity (PVIFA))

(P x Present Value Factor) = (5000 x 1\(1+r)^n)

where r= rate of return= 8%

n= years = 6

(Interest x The present value interest factor of an annuity (PVIFA) =

Interest = (Coupon rate x Investment)

PVIFA= 1\(1+r)^n}

where r= rate of return= 8%

n= years = 6

= (5000 x  0.6307) + (300 x 4.6223 )

=4540.19

5 0
3 years ago
What type of diversity is being implemented if a company is using multiple security products from different manufacturers?
son4ous [18]

Answer: vendor diversity

Explanation:

It is a program that permits an organization to connect with various clients and employees and also render assistance towards business and community growth. This program makes supply chain stronger which eventually leads to improvement in quality, innovation and efficiency.

3 0
3 years ago
Read 2 more answers
Pace corporation acquired 100 percent of spin company's common stock on January 1, 20X9. Balance sheet data for the two companie
Ray Of Light [21]

Answer:

Pace Corporation and Spin Company

1. Land should be reported in the consolidated balance sheet as

a. $130,000

2. Total assets:

b. $735,000

3. The differential associated with the acquisition:

b. $21,000

4. Goodwill

b. $21,000

5. Amount of liabilities in the consolidated balance sheet:

b. $406,000

Explanation:

a) Data:

Item                                                       Pace              Spin

                                                       Corporation     Company  

Cash                                                  $30,000        $25,000

Accounts Receivable                          80,000          40,000

Inventory                                            150,000          55,000

Land                                                    65,000          40,000

Buildings and Equipment                260,000         160,000

Less: Accumulated Depreciation   (120,000)        (50,000)

Investment: Spin Company Stock   150,000

Total Assets                                   $615,000       $270,000

Accounts Payable                         $45,000         $33,000

Taxes Payable                                20,000              8,000

Bonds Payable                             200,000          100,000

Common Stock                              50,000           20,000

Retained Earnings                       300,000          109,000

Total Liabilities and Stockholders’

  Equity                                      $615,000       $270,000

b) Consolidated Balance Sheets

Item                                     Pace             Spin            Total

                                      Corporation     Company    Group

Cash                                   $30,000      $25,000          $55,000

Accounts Receivable           80,000        40,000           120,000

Inventory                             150,000        60,000          210,000

Land                                     80,000        50,000           130,000

Buildings and Equipment 260,000       160,000         420,000

Less: Accumulated

  Depreciation                  (120,000)      (50,000)         (170,000)

Investment:

 Spin Company Stock      150,000                                 0

Goodwill                                                                           21,000

Total Assets                    $630,000    $285,000       $786,000

Accounts Payable            $45,000       $33,000         $78,000

Taxes Payable                   20,000            8,000           28,000

Bonds Payable                200,000        100,000         300,000

Common Stock                 50,000         20,000           50,000

Retained Earnings          300,000        109,000        300,000

Assets Revaluation           15,000          15,000          30,000

Total Liabilities and Stockholders’

  Equity                        $630,000     $285,000     $786,000

c) Differential on acquisition = investment (of subsidiary) - net assets

= $150,000 - ($270,000 - 141,000)  = $21,000

4 0
3 years ago
Most rejection messages sent to applicants are _________. select one:
labwork [276]

Specific in terms of reason for the injection

4 0
3 years ago
Read 2 more answers
Milltronics Industries has 2,900 defective units of product that have already cost $14.90 each to produce. A salvage company wil
sergiy2304 [10]

Answer:

Incremental income is $34,220.00  

Explanation:

                                                                                             Amount in $

Number of defective units (a)                                               2,900.00  

Cost of production per unit (b)                                               14.90  

Total cost of production (c = a x b)                                       43,210.00  

Proceed from sale of defective product per unit (d)               5.90  

Sale of defective product (e = d x a)                                       17,110.00  

Additional cost for correction of defect (f)                               5.10  

Cost for correction of defect (g = f x a)                               14,790.00  

Selling price per unit after correction of defect (h)               22.80  

Sales after correction of defect (i = h x a)                               66,120.00  

Incremental Income from sale (j = i - g - e)                              <u> 34,220.00</u>  

5 0
3 years ago
Other questions:
  • Matt lives in an apartment in New York. Every month, he must pay rent and
    12·1 answer
  • Cedar Designs​ Company, a custom cabinet manufacturing​ company, is setting standard costs for one of its products. The main mat
    6·1 answer
  • Beginning January 1, Community Hospital had 150 inpatient beds. On July 1, the bed count was increased to 200. From January 1 to
    14·1 answer
  • Suppose the U.S. dollar is defined by law as being equal to 0.1 ounce of gold. Further suppose the British pound is defined as b
    13·1 answer
  • One result of earnings management is:a.It brings into question the quality of earningsb.It uses a non-GAAP financial measure to
    9·1 answer
  • You're 35 years old now, and you want to purchase life insurance which will cover your spouse for your lost income in the event
    13·1 answer
  • On June 30, the end of the first month of operations, Tudor Manufacturing Co. prepared the following income statement, based on
    8·1 answer
  • If Division Inc. expects to sell 200,000 units in the current year, desires ending inventory of 24,000 units, and has 22,000 uni
    10·1 answer
  • Vaughn Manufacturing has fixed costs of $30000 per year. Its warehouse sells wine with variable costs of 90% of its unit selling
    5·1 answer
  • Consumers are required to apply their skill or analytical or creative thinking to try to win a prize in a(n)
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!