2 years ago

1) Write an SQL statement for the HAPPY INSURANCE database that adds the column ClientPhone to the table CLIENT.

Business

1 answer:

Sindrei [870]2 years ago

7 0

An SQL statement for the HAPPY INSURANCE database that adds the column ClientPhone to the table CLIENT is:

ALTER TABLE dbo.CLIENT

ADD ClientPhone

This refers to the use of databases to perform computations such as UPDATE, ADD, ALTER TABLE, etc.

Hence, the use of Structured Query Language would help to add to a database and this would be done using the ALTER TABLES function as shown above.

You might be interested in

Suppose a stock had an initial price of $58 per share, paid a dividend of $1.90 per share during the year, and had an ending sha

posledela

Answer: Dividend yield is 3.3%

Capital gains yield is 17.24%

Explanation:

Dividend yield is given as the ratio of annual dividend per share and stock's price per share.

Dividend per share = $1.9

Share price = $58

Dividend yield = 1.9/58 = 0.033 or 3.3%

Capital gain yield is the appreciation in the price of a stock expressed as a percentage.

Capital gain yield = (current price – original price) / original price x 100

Current price = $68

Original price = $58

CGY = (68-58)/58 * 100 = (10/58)*100 = 17.24%

4 0

3 years ago

Suppose that velocity is 3 and the money supply is $600 million. According to the quantity theory of money, nominal output equal

Tamiku [17]

Answer:

$1,800 million

Explanation:

According to the quantity theory of money , velocity = nominal output / money supply

If velocity is 3 and money supply is $600 million, nominal output = $1,800 million .

I hope my answer helps you

3 0

3 years ago

Interest inventory that classifies people according to 6 different types

harkovskaia [24]

What is the question asking !?

6 0

3 years ago

The United States and France both produce sweaters and caps. Suppose that a US worker can produce 50 caps per hour or 1 sweater

Andrews [41]

Answer
B
Explanation

5 0

3 years ago

McGuire Company acquired 90 percent of Hogan Company on January 1, 2010, for $234,000 cash. This amount is reflective of Hogan's

anzhelika [568]

Answer:

D. $1,800 Decrease

Explanation:

book value Fair value adjustment

01 Jan 10,000 8,000 2,000

Depreciation -1000 -800 -200

31 Dec 9,000 7,200 1,800 Decrease

5 0

3 years ago