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
A strategy of ____________ reciprocating both the frequency and magnitude of the other bargainer's concessions was found to be m
schepotkina [342]

Answer:

Always and less

Explanation:

Strategy: The strategy is a plan to do something with respect to achieve the company objectives or individual objective

Without preparing the strategy no one could accomplish their target.

For frequency and magnitude of other bargainer concessions, the strategy should always be reciprocatinvg and found to be more effectove as if concessions are obtained from other bargainer that involves less reciprocation

7 0
3 years ago
Clyde contracts with Deephole Excavation, Inc., to dig an agricultural pond on his farm. Deephole is to keep the excavated grave
anastassius [24]

Answer: Discharged

Explanation:

 Discharge contract is one of the type of concept that helps in making the various types of agreement between the two members or any two companies.

The discharged contract is basically discharged by using the various types of operation of laws and also b terminating the different types of obligations.

According to the given question, the Clyde contracts with the deep-hole excavation Inc., is one of the type of discharged contract for the process of digging an agriculture farm. Therefore, Discharged contract is the correct answer.  

8 0
3 years ago
The following are common categories on a classified balance sheet. a) Current assets b) Long-term investments c) Plant assets d)
noname [10]

Answer:

Land not currently used in operations - Long-term investments

Notes payable (due in five years) - Long-term liabilities

Accounts receivable - Current assets

Trademarks - Intangible assets

Accounts payable - Current liabilities

Store equipment - Plant assets

Wages payable - Current Liabilities

Cash - Current assets

8 0
3 years ago
Assume that you have a balance of $4000 on your credit card and that you make no more charges. If your APR is 23.9% and each mon
KatRina [158]

Answer:

The balance will be less than $100 after 44 months payment

Explanation:

In this question, we are asked to calculate the time at which the Balance on a credit card would be less than $100.

To calculate this, we proceed as follows;

The monthly Interest rate = 23.9%/12 = 1.99166667%

Balance after t months = Credit Card balance * [(1 + Monthly interest rate ) * (1- Minimum payment rate)]^t

The credit card balance is $4,000, and the minimum payment rate is 5%

We plug these values into the equation to get;

$4,000 * [(1+1.99166667%) * (1 - 5%)]^t

= $4000 *[1.0199166667 * 0.95]^t

= $4000 * (0.968920836)^t

Balance after t months < 100

$4,000 * (0.968920836)^t < 100

(0.968920836)^t < 0.025

t = 43.9 months = 44 months

6 0
3 years ago
Read 2 more answers
Robert wants to hire more employees for his doggie day-care business. Which of
aliina [53]

Answer:make a list of responsibilities and tasks that need to be accomplished in the business

Explanation:

3 0
3 years ago
Other questions:
  • Denise has her heart set on being a millionaire. What payment does Denise need to make at the end of each month over the coming
    15·1 answer
  • Please help me please
    13·1 answer
  • Identify which qualitative characteristic of accounting information is best described in each item below. (Do not use relevance
    7·1 answer
  • If a company adds a new product line to its existing​ portfolio, it has increased its___________.
    8·1 answer
  • The role of a labor union is to
    7·2 answers
  • Hawke Company had the following assets and liabilities on the dates indicated. December 31 Total Assets Total Liabilities 2019 $
    8·1 answer
  • Operating data for Bramble Corp. are presented below.
    12·1 answer
  • Digit designs manufactures high-quality gloves and other accessories. it already uses both computer-aided design and computer-ai
    8·1 answer
  • The market price of a bond is equal to the present value of the: Group of answer choices annuity payments plus the future value
    7·2 answers
  • The graph shows the price of a good compared to the quantity demanded and the quantity supplied. A graph titled Price Controls G
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!