# (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class;

Consider the table STUDENT given below:RollNoNameClassDOBGenderCityMarks1AnandXI6/6/97MAgra4302ChetanXII7/5/94MMumbai4603GeetXI6/5/97FAgra4704PreetiXII8/8/95FMumbai4925SaniyalXII8/10/95MDelhi3606MaakhiyXI12/12/94FDubai2567NehaX8/12/95FMoscow3248NishantX12/6/95MMoscow429(1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class;but she is not getting the desired result. Help her by writing the correct command.a. Select max(marks) from student where group by class;b. Select class max(marks) from student group by marks;c. Select class max(marks) group by class from student;d. Select class max(marks) from student group by class;(2) State the command to display the average marks scored by students of each gender who are in class XI?i. Select gender avg(marks) from student where class= “XI” group by gender;ii Select gender avg(marks) from student group by gender where class=”XI”;iii. Select gender avg(marks) group by gender from student having class=”XI”;iv. Select gender avg(marks) from student group by gender having class = “XI”;Choose the correct option: a. Both (ii) and (iii) b. Both (ii) and (iv) c. Both (i) and (iii) d. Only (iii)(3) Help Ritesh to write the command to display the name of the youngest student?a. select namemin(DOB) from student;b. select namemax(DOB) from student;c. select namemin(DOB) from student group by name;d. select namemaximum(DOB) from student;

(1)  d. Select class, max(marks) from student group by class; (2)  b. Both (ii) and (iv) (3)  b. select name,max(DOB) from student;