1.

Consider a table FACTORY:YEARProduction200812000200910000201010600201115000201214500Reema wants to calculate the average production of the years 2008-2012. Help her select the correct SQL command for it:a. SELECT AVERAGE(Production) from FACTORY; b. SELECT AVERAGE(Production) from FACTORY group by Production; c. SELECT SUM(Production) from FACTORY; d. SELECT AVG(Production) from FACTORY;

Answer»

Correct option: d. SELECT AVG(Production) from FACTORY;



Discussion

No Comment Found

Related InterviewSolutions