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 a report with adno,name,average*5 as total marks from student table.

Answer 1

SELECT Adno, Name, Average * 5 AS TotalMarks FROM Students;