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
What tips should he follow? Check all that apply. Cross your arms in front of you. Stand with your hands in your pockets. Don’t
Marta_Voda [28]

Answer:

  • Don't Chew Gum
  • Listen Attentively
  • Sound Enthusiastic and Sincere
  • Use proper language and enunciate clearly

Explanation:

(Avoid Clarifying vague questions might be an answer but not sure. I'm sorry if I am wrong)

8 0
3 years ago
Sloane tells eden that brad is a horrible son to his mother. brad sues for defamation even though he suffered no injury. brad wi
cricket20 [7]

"Defamation of character"

Is a catch-all term for any statement that hurts someone's reputation. Written defamation is called "libel," while spoken defamation is called "slander." Because written statements last longer than spoken statements, most courts, juries, and insurance companies consider libel more harmful than slander.

Defamation is not a crime in most states, but it is a "tort" (a civil wrong, rather than a criminal wrong). The person who has been defamed (the "plaintiff") can sue the person who did the defaming (the "defendant") for damages.

Defamation law tries to balance competing interests: On the one hand, someone shouldn't be able to ruin your life by telling lies about you; on the other hand, people should be able to speak freely without fear of litigation over every insult, disagreement, or mistake. Political and social debate is important in a free society, and we obviously don't all share the same opinions or beliefs. For example, political opponents often reach opposite conclusions from the same facts, and editorial cartoonists often exaggerate facts to make their point.

How Do You Prove Defamation?

Defamation happens when a person makes a false statement—verbally or in writing—about someone else that damages that person's reputation. Defamation laws vary from state to state, but the basic principles of defamation law are the same in every state.

A plaintiff suing for defamation typically must show:

  • The defendant published a statement about the plaintiff.
  • The statement was false.
  • The statement was injurious, and
  • The statement was unprivileged. .

Defenses to Defamation Lawsuits :

Defamation claims are complicated and hard to prove because defamation laws have to strike a balance between allowing people to protect their reputations and allowing the free exchange of information, ideas, and opinions.

You can defend yourself against a defamation lawsuit if the statement you made was:

  • true
  • an opinion
  • privileged  or
  • retracted.

Learn more about Defamation :

brainly.com/question/14634806

#SPJ4

5 0
2 years ago
Managers make assumptions in CVP analysis. These assumptions include: (Check all that apply.) Multiple select question. some uni
BigorU [14]

The assumptions that are made in CVP analysis includes the following:

  • costs can be classified as variable or fixed.
  • costs are linear within the relevant range.
  • constant fixed cost per unit.

<h3>What is CVP analysis?</h3>

Cost Volume Profit analysis is the type of analysis that has to do with the cost accounting. This type of analysis is one that takes the impact of the various costs and volume on profit.

It helps to check how the changes that occur in the variable and the fixed cost affect profit.

Read more on CVP analysis here:

brainly.com/question/26654564

#SPJ1

4 0
2 years ago
10 percent partner in a partnership that incurred a $4 million business loss this year. Jahlil has no other business activities.
sashaice [31]

Answer:

$250,000 and $500,000

Explanation:

According to the tax laws there is annual limit on Loss deductions  relating the amount of business loss that can be deducted in a year.

The law states that single or individual tax payers can deduct nothing more than $250,000 while married taxpayers who are filing jointly can deduct up to $500,000 per year of their business losses.

Therefore, if Jahlil is single the amount of partnership loss he can deduct is $250,000 but if he is married filing jointly, he can deduct $500,000

6 0
3 years ago
Taxation of Business Entities, 2016 edition7-65.) Wolverine Corporation made a distribution of $500,000 to Jim Har Inc. in par-t
marusya05 [52]

Answer:

a. Dividend

b. $500,000

Explanation:

a. As in the given case, the character of any income or gain recognized is the dividend of $500,000 which eligible him to avail 100% deduction of the dividend amount

b. The reduced amount would be lower of the distributed amount or 50% of Total E&P

Distributed amount is $500,000

And, the 50% of total E&P is =  $8,000,000 × 50% = $4,000,000

So, the lesser amount is $500,000 which is reduced its total E&P

5 0
3 years ago
Other questions:
  • Fixed rate mortgage offer: Principal: $170,000 Term: 30 years Interest rate: 4.25%Use this fixed-rate mortgage calculator to hel
    7·1 answer
  • You own 180 shares of stock in Halestorm, Inc., that currently sells for $82.45 per share. The company has announced a dividend
    6·1 answer
  • Merriweather Post Pavillion received a $820 check from a customer for the balance of accounts due. The transaction was erroneous
    12·1 answer
  • Many employees get a reality shock on their first day at work because ____.
    5·1 answer
  • Mainstream economic theorizing sees work as a lousy activity that workers tolerate in order to earn income. One way that work is
    13·1 answer
  • How are comments visually indicated on a slide?
    5·2 answers
  • 8. Why is the failure of a large bank more detrimental to the economy than the failure of a large steel manufacturer?
    11·1 answer
  • The balance sheet items of Kiner company as of December 31, current year, follow in random order
    14·1 answer
  • Why can most people in Hospitality and Tourism careers succeed with a secondary education as their highest level of education? M
    9·1 answer
  • When making keep or replace decisions, management should consider the: (Check all that apply.)
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!