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' name and average marks, whose scode is 222 and 333.

Answer 1

SELECT Name, Average FROM Students WHERE Scode IN (222, 333);