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.

Answer 1

SELECT * FROM Students WHERE Average > 80 AND Scode = 333;