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: StudentID Name Age Gender Grade Sarah Female Mohamed Male Maryam Female Saeed Male Omer Male Retrieve the Name and Age of students with a Grade greater than Retrieve the count of Male students in the student table. Retrieve the average Grade of all students. Update the Grade of the student with StudentID to Delete the record of the student named "Ahmed". 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
