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)

A) Create table TotalByCountry from developer select CountryOfBirth

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

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

D) Select developer into sum(BonusAmount) having CountryOfBirth

A) Create table TotalByCountry from developer select CountryOfBirth

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

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

D) Select developer into sum(BonusAmount) having CountryOfBirth

Explanation / Answer

ANs:

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

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects