A table Student consists of fields Roll No, Name, Batch and Percent.
Write SQL statements to
1. Display Roll No and Name of students whose percentage is Iessthan90 and greater than 70.
2. Display Roll No and Name of all students in science batch whose percentage is more than
3. Display Names of all students in commerce and science batches.
4. Display the average Percent of students in each batch.
5. Display Roll No and Name in the ascending order of Batch and descending order of Percent.