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
In the second half of 2019, automobile sales in the United States were lower than they were in the second half of 2018. The decr
Monica [59]

In the second half of 2019, automobile sales in the United States were lower than they were in the second half of 2018. The decrease in auto sales impacts GDP because new automobiles are counted as <u>consumption </u>when purchased by households and <u>investment</u> when purchased by businesses.

Gross domestic product (GDP) is the overall monetary or market value of all of the goods and services produced within a country's borders in a particular time period.

GDP can be calculated by adding up all of the money spent by consumers, businesses, and the government in a given period. It may also be calculated by adding up all of the money received by all the participants in the economy.

learn more about Gross domestic product (GDP) here

brainly.com/question/1383956

#SPJ4

3 0
2 years ago
Listed below are ten independent situations. For each situation indicate (by letter) whether it will create a deferred tax asset
valkas [14]

Answer:

1. Advance payments on insurance, deductible when paid.

Indication: Deferred tax liability (L)

2. Estimated warranty costs; tax deductible when paid.

Indication: Deferred tax asset (A)

3. Rent revenue collected in advance; cash basis for tax purposes.

Indication: Deferred tax asset (A)

4. Interest received from investments in municipal governmental bonds.

Indication: Neither (N)

5. Prepaid expenses, tax deductible when paid.

Indication: Deferred tax liability (L)

6. Net operating loss carryforward.

Indication: Deferred tax asset (A)

7. Net operating loss carryback.

Indication: Neither (N)

8. Straight-line depreciation for financial reporting; MACRS for tax purposes.

Indication: Deferred tax liability (L)

9. Organization costs expensed when incurred; tax deductible over 15 years.

Indication: Deferred tax asset (A)

10. Life insurance proceeds received upon the death of the company president.

Indication: Neither (N)

3 0
3 years ago
Suppose a wealthy French citizen buys $2 million worth of stock issued by an American corporation. The American firm uses the pr
Aleks04 [339]

Answer: 1. Portfolio

2. • Protecting property rights and enforce contracts.

• Providing tax breaks and patents for firms that pursue research and development in health and sciences.

3. All of the above

Explanation:

1. Since the wealthy French citizen buys $2 million worth of stock issued by an American corporation and the American firm uses the proceeds for a factory expansion, then this is considered to be an example of foreign portfolio investment in the United States.

2. The policies that are consistent with the goal of increasing productivity and growth in developing countries include:

• Protecting property rights and enforce contracts.

• Providing tax breaks and patents for firms that pursue research and development in health and sciences.

3. The possible outcomes of rapid population growth include a reduction in the human capital per worker, a reduction in capital per worker and an increase in technological knowledge. Therefore, the answer is all of the above.

8 0
3 years ago
QUESTION 1
Klio2033 [76]

The format button is used to format a table's text to make it more interesting in PowerPoint.

<h3>What is the work of the Format button?</h3>

As the name suggests, the Format button is used to format the text, table, size, etc. And make more interesting in the PowerPoint, MA word, MS Excel.

The formatting button is used to make the more interesting and attractive texts, tables, pictures, etc.

Therefore, the formatting button is used to make more interesting the text of the table.

Learn more bout the format button, refer to:

brainly.com/question/8517487

4 0
2 years ago
Read 2 more answers
Speedy Bikes could sell its bicycles to retailers either assembled or unassembled.
Feliz [49]

Answer:

Speedy Bikes

a. Incremental Analysis for the sell-or-process-further decision:

                                                       Cost of an              Cost an    Difference

                                                   unassembled bike  assembled bike

                                                     Alternative 1          Alternative 2 Increment

Sales price of unassembled bike      $450                     $495           $45

Manufacturing cost per unit              $290                      $312            (22)

Net operating income                        $160                       $183           $23

b. Speedy should process the bikes further.

c. It will generate an incremental net operating income of $23 per bike.

Explanation:

a) Data and Calculations:

                                                       Cost of an              Cost an

                                                   unassembled bike  assembled bike

Direct materials                                    $150                      $155

Direct labor                                               70                         80

Variable overhead (70% of direct labor) 49                         56 ($80 * 70%)

Fixed overhead (30% of direct labor)      21                          21

Manufacturing cost per unit               $290                      $312

7 0
2 years ago
Other questions:
  • A manufacturer with a product in the decline stage of the product life cycle would most likely decide to ________ if there is re
    6·1 answer
  • The Tenant is responsible for insuring the Property for damage or loss to the structure, mechanical or improvements to the build
    14·1 answer
  • Every Bill which shall have passed the House of Representatives and the Senate, shall, before it become a Law, be presented to t
    8·1 answer
  • Most companies use​ ________ when the managers develop budgets each year.
    5·1 answer
  • Martin purchased municipal bonds that yield 7% annually and certificates of deposit which yield 9% annually.
    14·1 answer
  • Explain in your own words why "deep kissing" is considered a risk behavior for contracting hiv.
    9·1 answer
  • What does Pa think is too close to the Ingallses' house?
    8·1 answer
  • The least likely factor a business will use to determine a benchmark is
    7·1 answer
  • A 10-year loan of 120,000 is to be repaid with payments at the end of each month. Interest is at an annual effective rate of 6.0
    13·1 answer
  • Explain the following quote "The rich rule over the poor, and the borrower is slave to the lender."
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!