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
Svetllana [295]
3 years ago
9

The CFO of company ABC wants to give every employee a 3% raise, but would like a report to confirm if this is possible. Write an

SQL statement that would pull this report from the Employee table. They are requesting just the Employee ID, Current Salary, and Salary plus 3%. Salary is saved in the database for the employees annual pay.
Business
1 answer:
katrin [286]3 years ago
4 0

Answer:

For such a report , the sql query required would be:

SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;

Explanation:

For such a report , the sql query required would be:

SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;

In the above  sql query  employee id is emp_id , curr_salary is the current salary column.  "curr_salary*1.03" is been made because an increment of 3% means salary + salary*3% , that is , salary*1.03.

You might be interested in
These degrees are offered by state universities and private colleges/universities and include Masters and Doctoral degrees.
ira [324]
What is the question?
3 0
3 years ago
The job outlook for physical therapists
dusya [7]

The job outlook for physical therapists B. depends on the economy. Jobs in general depend on the economy and the needs of those within it. If there is a high need for physical therapists, then the will improve or remain stable over time. If the economy starts to decline, there may be a lesser need or opportunity for physical therapists (and other professions) to find work.

8 0
2 years ago
Read 2 more answers
All of these are functions of money EXCEPT :________
tino4ka555 [31]

Answer:

c

Explanation:

it doesn't make sense to be a function of money

8 0
2 years ago
Cracker Company had 2 million shares of common stock outstanding all through 2017. On April 1, 2018, an additional 100,000 share
JulsSmile [24]

Answer:

a. $ 2.41 $ 2.00

Explanation:

Earning per share is the ratio of net Income of the business per outstanding share of the business after deducting the preferred dividend from net earning. It shows how much each stockholder earn against their each share in a specific period.

Earning Per share = Net Income / Outstanding numbers of shares

2017

EPS = $8,000,000/(2,000,000 x 2) = $2.00

As new stock is issued and stock split is declared so, outstanding numbers of shares are changed.

2018

EPS = $10,000,000 / [ ( 2,000,000 x 2 ) + ( 100,000 x 9 / 12 x 2 ) ] = $2.41

8 0
3 years ago
Consider an investment with the returns over 4 years as shown​here:
xeze [42]

Answer:

Explanation:

Assume the initial invest at the beginning is $100.

The investment at end of year 4 is:

100 x 1.16 x 1.11 x 1.1 x 1.1 = 155.80

a) CAGR over the 4 years = (155.8 / 100 ) ^ (1/4) = 11.72%

b) Average annual return over 4 years = (16% +11% + 10% +10%) /4 = 11.75%

c) Since the returns over the 4 year period are not much volatile, average annual return is a better measure.

If the investment's returns are independent and identically distributed, Average annual return will be the better measure because there is no correlation between returns over the years and thus there is no point to take into consideration the compounding effect by using CAGR.

8 0
3 years ago
Read 2 more answers
Other questions:
  • If a bakery hires on person to bake cookies and another to bake cakes,the bakery is applying the concept of specialization.
    11·1 answer
  • Critical Thinking Questions What investment options are open to Natasha? What chance does she have of earning a satisfactory ret
    8·1 answer
  • Compute the impact on the money multiplier of an increase in the currency-to-deposit ratio from 10 percent to 15 percent when th
    6·1 answer
  • A Third World country can be described as a(n) __________ country.
    10·1 answer
  • Maria works for megacorp, a large privately owned company specializing in sales of ball bearings. megacorp introduces filtering
    11·1 answer
  • A client has a Cash Account at a broker-dealer and one week ago was sold out of a position for failure to make prompt payment. T
    13·1 answer
  • According to the Department of Labor finishing even one year of college raises the average person's income a lot for the rest of
    11·2 answers
  • Bailey Hill Co. uses the indirect method to determine its net cash flows from operating activities. During the course of the yea
    11·1 answer
  • Meaning use of proof readers sign​
    14·1 answer
  • The two accounting principles that are critical to the adjusting process used in accrual accounting are:_______
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!