Question: Can someone help me write queries for 2-10? SQL. Information Below ID Name Email Phone Start_Year GPA 1 Alice Brown browna@far.edu 631-123-4567 2013 3.6 2
Can someone help me write queries for 2-10? SQL. Information Below

ID Name Email Phone Start_Year GPA 1 Alice Brown browna@far.edu 631-123-4567 2013 3.6 2 Bob Bush bushb@far.edu 212-485-9383 2014 2.8 3 Carl Menchin menchinc@far.edu917-987-3824 2012 3.1 4 David Lieberman liebed@far.edu 234-837-9872 2013 2.9 5 John Capra capraj@far.edu 234-432-0092 2011 2.3 6 George Smith smithg@far.edu 564-332-1109 2013 2.7 7 Elaine Sanders sanderse@far.edu760-345-4436 2011 3.0 8 Jack Cunningham cunninghamj@far.edu556-433-8901 2014 2.8 9 Susie Brown browns@far.edu 631-880-0981 2015 3.0 10 Marvella Garcia garciam@far.edu 662-980-1120 2013 2.8 11 Tony Peterson petersont@far.edu212-990-2230 2014 2.3 12 John Jones jonesj@far.edu 631-334-5678 2013 2.5 13 Mary Evans evansm@far.edu 631-442-7836 2011 3.1 14 Nancy Drew drewn@far.edu 631-344-9002 2013 3.5 15 Lola Zapeta zapetal@far.edu 212-801-8734 2015 2.4 16 Duckey Donald donaldd@far.edu 212-478-0921 2013 2.7 17 Goof Goofy goofyg@far.edu 631-990-1114 2012 2.9 18 Brave Balto baltob@far.edu 212-330-4301 2014 2.3 19 Snow Smith smiths@far.edu 212-209-4490 2013 2.9 20 William Whitman whitmanw@far.edu631-908-0091 2015 3.8
l. Find the names and emails of all students and display them in the ascending order of name. 2. Find the id and name of all students whose start year is the same as Alice Brown. 3. Find the id, name, and gpa of all students whose gpa is between 2.0 and 3.0. 4. Find the id, name, and gpa of all students in the descending order of gpa 5. Find the average gpa of all students as AverageGPA. 6. Find the average gpa of students for each start year 7. Find the number of students for each start year. 8. Find the id, name, phone, start year of the student who has the highest gpa. 9. Update John Jones's phone number to 111-222-3333. 10. Delete Goof Goofy's record from students table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
