Choose the script that will create a NEW table with data from the existing devel

Question

Choose the script that will create a NEW table with data from the existing developer table named TotalByCountry which has the total bonus per CountryOfBirth for all developers. (choose one) (10 pts)

Create table TotalByCountry from developer select CountryOfBirth

Alter table Developer into TotalByCountry Total(Bonus) group by CountryofBirth

Select CountryOfBirth, sum(BonusAmount) into TotalByCountry from developer group by CountryOfBirth

Select developer into sum(BonusAmount) having CountryOfBirth

Create table TotalByCountry from developer select CountryOfBirth

Alter table Developer into TotalByCountry Total(Bonus) group by CountryofBirth

Select CountryOfBirth, sum(BonusAmount) into TotalByCountry from developer group by CountryOfBirth

Select developer into sum(BonusAmount) having CountryOfBirth

Explanation / Answer

script that will create a NEW table with data from the existing developer table named TotalByCountry which has the total bonus per CountryOfBirth for all developers Create table TotalByCountry from developer select CountryOfBirth.

OPTION 1 CORRECT

Explanation:

To create new table we use the command create.

Here new table name is TotalByCountry .

To select the paticular data we use the command select.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects