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 Average Division
1 Sharon 400 English 38 THIRD
2 Amal 680 Mathematics 72 FIRST
3 Vedant 500 Accounts 67 FIRST
4 Shakeer 300 Informatics 55 SECOND
5 Anandha 40 History 85 FIRST
6 Upasna 550 Geography 45 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

Answer:

to list the tabala result given below. write command in MySQL for a to d and output for e to g