Question

Development Project1
Consider the table RESULT given below. Create the table and enter the data. Then create a query to answer the following questions. You can save the queries with suitable names yourself.
Table : Result
No Name Stipend Subject Averge Yes/No Division
1 Sharon 400 English 38 No THIRD
2 Amal 680 Mathametics 72 No FIRST
3 Vedant 500 Accounts 67 No FIRST
4 Shakeer 300 Informatics 55 No SECOND
5 Anandha 40 History 85 No FIRST
6 Upasna 550 Geography 45 No THIRD
a. Set the required field for Average as "Yes”.
b. Display all the names of the students with the stipend they are getting.
c. Show the details of all students who have got average more than 50.

Answer 1

Explanation:

don't know what is the answer