Using the relational table below

Create 3 SQL queries that will

1.Find the number of students applying to a degree program, for each degree program by prior degree.

2. Find the number of applications submitted/accepted/denied by program and year

3. Find the minimum, maximum, average, and standard deviation of the GRE scores of the applicants, by program and application year.

applicants studentiD INT first-name VARCHAR(45) lat name VARCHAR(45) gender ENUM(M,'F','0'> emal VARCHAR(45) pnoneNum VARCHAR(50) appicatonD INT semester VARCHARI45 year VARCHAR(45) GRE-analytical INT GRE-quartielive INT GRE verbdINT oun ersty VARCHAR(45) applications_satisfies_requirements date-of-birth DATE city VARCHAR(45) major VAROHAR(45) requrements questionNum INT trequrements degre program_name VARCHAR(45) FLOAT ograduaton dat! DATE degree VARCHAR(45) em al 1 VARCHAR(45) em .12 VARO AR(45) emal 3 VARCHAR(45) essay VARCHAR(300) requirements questorNum INT queston VAROIAR(60) answer VARCHAR(200) t degree program name VARCHAR. street VARCHAR(45) response ENUM(YN) PRIMARY PRIMARY fk applicatons has_requrements_requrements1Ldx icants-studentID INT degree_program-nam e VARCHAR(45) fk requirements degree program 1. PRIMAR fk appl catons_degree program 1.dx program name VARCHAR(45) namdirector VARCHAR(45) phoneNumber VARCHAR(45) email VARCHAR(45) application_evaluation_has_rubric faau tyeD INT odete evduated DATETIME date dedsion DATETIME admit/deny ENUM(A', b') tapplicatons appicetionID INT rubric rubricID NT crieia VARCHAR(300) degree program _name VARCHAR PRIMARY applicaton evaluaton applicatons applratonlD INT rubric nibndaD INT program name UNIQUE t rubric-degreeprogram,name VAR AR(45) score INT PRIMARY PRIMARY PRIMARY fk applicaton evaluaton appicatons1 idx xppicaton wluaton has_rubrir applcatn valuton_dx destripton VARCHAR(100) 'alue INT rubric_rubnicID INT rubric dereeprogrem name FRIMARY kscores rubri:1 id applicants studentiD INT first-name VARCHAR(45) lat name VARCHAR(45) gender ENUM(M,'F','0'> emal VARCHAR(45) pnoneNum VARCHAR(50) appicatonD INT semester VARCHARI45 year VARCHAR(45) GRE-analytical INT GRE-quartielive INT GRE verbdINT oun ersty VARCHAR(45) applications_satisfies_requirements date-of-birth DATE city VARCHAR(45) major VAROHAR(45) requrements questionNum INT trequrements degre program_name VARCHAR(45) FLOAT ograduaton dat! DATE degree VARCHAR(45) em al 1 VARCHAR(45) em .12 VARO AR(45) emal 3 VARCHAR(45) essay VARCHAR(300) requirements questorNum INT queston VAROIAR(60) answer VARCHAR(200) t degree program name VARCHAR. street VARCHAR(45) response ENUM(YN) PRIMARY PRIMARY fk applicatons has_requrements_requrements1Ldx icants-studentID INT degree_program-nam e VARCHAR(45) fk requirements degree program 1. PRIMAR fk appl catons_degree program 1.dx program name VARCHAR(45) namdirector VARCHAR(45) phoneNumber VARCHAR(45) email VARCHAR(45) application_evaluation_has_rubric faau tyeD INT odete evduated DATETIME date dedsion DATETIME admit/deny ENUM(A', b') tapplicatons appicetionID INT rubric rubricID NT crieia VARCHAR(300) degree program _name VARCHAR PRIMARY applicaton evaluaton applicatons applratonlD INT rubric nibndaD INT program name UNIQUE t rubric-degreeprogram,name VAR AR(45) score INT PRIMARY PRIMARY PRIMARY fk applicaton evaluaton appicatons1 idx xppicaton wluaton has_rubrir applcatn valuton_dx destripton VARCHAR(100) 'alue INT rubric_rubnicID INT rubric dereeprogrem name FRIMARY kscores rubri:1 id