Question: The following is a Student Table from a database. Write your SQL queries to answer the following questions: Student _ ID , Name, Age, Gender,

The following is a Student Table from a database. Write your SQL queries to answer the following questions:
Student_ID, Name, Age, Gender, Grade
1,Sarah, 18, Female, 90
2,Mohamed, 19, Male, 85
3, Ahmed, 17, Male, 77
4, Maryam, 18, Female, 92
5, Saeed, 20, Male, 87
1- Retrieve the Name and Age of students with a Grade greater than 89.
2- Retrieve the count of Male students in the student table.
3- Retrieve the average Grade of all students.
4- Update the Grade of the student with Student_ID 3 to 90.
5- Delete the record of the student named "Ahmed".
6- Insert a new student into the table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!