I need only sql select statement.. please dont give me any kind of answer Displa
ID: 3852856 • Letter: I
Question
I need only sql select statement.. please dont give me any kind of answer Display all non web students Sort date based on student's spa from lowest to highest 3 Please write down SQt select statement to generate and display results based on following criteria 3columns: maior, number of student, and average of gpa Display all students. Sort data based on student's major in alphabetical order 4. Please write down SQL select statement to generate and display results based on following criteria . 5 columns: student initial, number of student, and average of gpa D Display all students. .Sort data based on student's initial in alphabetical order 5. Please write down SQL select statement to generate and display results t to generate and display results based on following criteria 5 columns: student initial, number of student, and average Of Rea Display all students with st Sort dato ay all students with student's last-name initial is either 'B','G', or 'FD based on average of gpa from lowest to highestExplanation / Answer
3. The following SQL SELECT statement returns the data based on Student's major in Alphabetical order.
SQL Statement:
SELECT major, COUNT(student), AVG([Table_Name].gpa) FROM [Table_Name] GROUP BY major ORDER BY major
4. The following SQL SELECT statement returns the sorted data based on Student's initial in Alphabetical order.
SQL Statement:
SELECT Student_Initial, COUNT(student), AVG([Table_Name].gpa) FROM [Table_Name] ORDER BY Student_Initial
5. The following SQL SELECT statement returns all students with student's Last_name initial is either 'B', 'G' or 'F' and sort the data based on average of GPA from Lowest to Highest that means in Ascending order.
SQL Statement:
SELECT Student_Initial, COUNT(student), AVG([Table_Name].gpa) FROM [Table_Name] WHERE Last_Name LIKE '[BGF]%' ORDER BY AVG([Table_Name].gpa) ASC