Based on above student and enrollment tables, show

1) Step-by-step algebra to find snumand name of students who are IS major and has GPA greater than 3.0

2) Step-by-step algebra to find name of students whose GPA is between (including)

3.0 and 3.4

3) Step-by-step algebra to find snumof students who do not live in zip 91101

4) Step-by-step algebra to find snumof students have never enrolled in any class

5) Step-by-step algebra to find students who have never received an A

6) Step-by-step algebra to find snum and sname of students who took the course IS380 with a grade better than C

-- Students Snum Status GPA Zip code Major IS 101 3.5 91101 102 MKT 2.8 91102 Sname Andy Betty Cindy David Tom 103 IS senior Junior Senior Junior freshman 3.0 91103 104 3.2 91104 105 MKT 2.7 91102 -- Enrollments Snum Course Semester Grade 101 IS300 2014 101 IS380 20145 102 2014S 102 IS380 IS380 IS480 2014F 101 2015 103 IS300 2015S 102 ID301 2015 -- Students Snum Status GPA Zip code Major IS 101 3.5 91101 102 MKT 2.8 91102 Sname Andy Betty Cindy David Tom 103 IS senior Junior Senior Junior freshman 3.0 91103 104 3.2 91104 105 MKT 2.7 91102 -- Enrollments Snum Course Semester Grade 101 IS300 2014 101 IS380 20145 102 2014S 102 IS380 IS380 IS480 2014F 101 2015 103 IS300 2015S 102 ID301 2015