1.Create a student table with FirstName, LastName,Dob,Gender,TotalMarks,City and State as columns.
2.Insert 20 hetrogenious records in the student table.
select * from Student
3.Select the student list who are all living in city chennai.
4.Select the student list according to the TotalMarks in ascending order.
5.Select the student list according to the FirstName in descening order.
6.Select the student list who are all living other than TamilNadu.
7.Select the student list who are having marks greater than 100 and not living in the state TamilNadu.
8.Select the female student list according to the Dob in descending order.
9.Select the male student list according to the TotalMarks in ascending order.
10.Show the state of the student who scored more than 250.
