I creaeted the table, I just need help with questiuons 10-12

create table MBA_Admissions

(

ApplicantID int,

GPA decimal(4,2),

GMAT_score int,

Decision varchar(20)

)

insert into MBA_Admissions

values

(101,2.96,596,'admit'),

(102,3.14,473,'admit'),

(103,3.22,482,'admit'),

(104,3.29,527,'admit'),

(105,3.69,505,'admit'),

(106,3.46,693,'admit'),

(107,3.03,626,'admit'),

(108,3.19,663,'admit'),

(109,3.63,447,'admit'),

(110,3.59,588,'admit'),

(111,3.3,563,'admit'),

(112,3.4,553,'admit'),

(113,3.5,572,'admit'),

(114,3.78,591,'admit'),

(115,3.44,692,'admit'),

(116,3.48,528,'admit'),

(117,3.47,552,'admit'),

(118,3.35,520,'admit'),

(119,3.39,543,'admit'),

(120,3.28,523,'admit'),

(121,3.21,530,'admit'),

(122,3.58,564,'admit'),

(123,3.33,565,'admit'),

(124,3.4,431,'admit'),

(125,3.38,605,'admit'),

(126,3.26,664,'admit'),

(127,3.6,609,'admit'),

(128,3.37,559,'admit'),

(129,3.8,521,'admit'),

(130,3.76,646,'admit'),

(131,3.24,467,'admit'),

(132,2.54,446,'notadmit'),

(133,2.43,425,'notadmit'),

(134,2.2,474,'notadmit'),

(135,2.36,531,'notadmit'),

(136,2.57,542,'notadmit'),

(137,2.35,406,'notadmit'),

(138,2.51,412,'notadmit'),

(139,2.51,458,'notadmit'),

(140,2.36,399,'notadmit'),

(141,2.36,482,'notadmit'),

(142,2.66,420,'notadmit'),

(143,2.68,414,'notadmit'),

(144,2.48,533,'notadmit'),

(145,2.46,509,'notadmit'),

(146,2.63,504,'notadmit'),

(147,2.44,336,'notadmit'),

(148,2.13,408,'notadmit'),

(149,2.41,469,'notadmit'),

(150,2.55,538,'notadmit'),

(151,2.31,505,'notadmit'),

(152,2.41,489,'notadmit'),

(153,2.19,411,'notadmit'),

(154,2.35,321,'notadmit'),

(155,2.6,394,'notadmit'),

(156,2.55,528,'notadmit'),

(157,2.72,399,'notadmit'),

(158,2.85,381,'notadmit'),

(159,2.9,384,'notadmit'),

(160,2.86,494,'border'),

(161,2.85,496,'border'),

(162,3.14,419,'border'),

(163,3.28,371,'border'),

(164,2.89,447,'border'),

(165,3.15,313,'border'),

(166,3.5,402,'border'),

(167,2.89,485,'border'),

(168,2.8,444,'border'),

(169,3.13,416,'border'),

(170,3.01,471,'border'),

(171,2.79,490,'border'),

(172,2.89,431,'border'),

(173,2.91,446,'border'),

(174,2.75,546,'border'),

(175,2.73,467,'border'),

(176,3.12,463,'border'),

(177,3.08,440,'border'),

(178,3.03,419,'border'),

(179,3,509,'border'),

(180,3.03,438,'border'),

(181,3.05,399,'border'),

(182,2.85,483,'border'),

(183,3.01,453,'border'),

(184,3.03,414,'border'),

(185,3.04,446,'border')

Question 9:

Write a query to return the average GMAT score( column name as 'Average GMAT'), maximum GMAT score( column name as 'Maximum GMAT')

and minimum GMAT score( column name as 'Minimum GMAT') of the MBA applicants

Question 10:

Write a query to return the average GMAT score( column name as 'Average GMAT')and average GPA ( column name as 'Average GPA')of the MBA applicants

Question 11:

Write a query to return the type of decision and the number of applicants that were awarded a specific decision

Quetion 12:

Write a query to return the average GPA of MBA applicants whose GPA score is greater than 3