Write query based upon item table given. Display students' info., who are getting average marks of more than 80 and scode 333.
Advertisements
Advertisements
Question
Write query based upon item table given.
Students
| Adno | Name | Average | Sex | Scode |
| 501 | R.Jain | 98 | M | 111 |
| 545 | Kavita | 73 | F | 333 |
| 705 | K.Rashika | 85 | F | 111 |
| 754 | Rahul Goel | 60 | M | 444 |
| 892 | Sahil Jain | 78 | M | 333 |
| 935 | Rohan Saini | 85 | M | 222 |
| 955 | Anjali | 64 | F | 444 |
| 983 | Sneha Aggarwal | 80 | F | 222 |
Display students' info., who are getting average marks of more than 80 and scode 333.
Code Writing
Advertisements
Solution
SELECT * FROM Students WHERE Average > 80 AND Scode = 333;shaalaa.com
Is there an error in this question or solution?
Chapter 10: Structure Query Language - EXERCISE [Page 200]
