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

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 902 Mohamed 19 Male 853 Maryam 18 Female 904 Saeed 20 Male 875 Omer 21 Male 891- 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!