Question

Predict the output if the following SQL queries from the given table: SCHOOLDATA

TABLE: SCHOOLDATA
Admno	Name	Class	House	Percent	Gender	Dob
20150001	Aditya Das	10	Green	86	Male	2006-02-20
20140212	Harsh Sharma	11	Red	75	Male	2004-10-05
20090234	Swapnil Pant	10	Yellow	84	Female	2005-11-21
20130216	Soumen Rao	9	Red	91	Male	2006-04-10
20190227	Rahil Arora	10	Blue	70	Male	2005-05-14
20120200	Akasha Singh	11	Red	64	Female	2004-12-16

1. SELECT MAX(Percent) FROM SCHOOLDATA;
2. SELECT LEFT(Gender,1),Name FROM SCHOOLDATA WHERE YEAR(Dob)=2005;

Answer 1

1. Percent
   .................
   91
2. Gender      Name
   .......................................
   F               Swapnil Pant
   M             Rahil Arora