Consider the following Emp table, eid Name age salary 401 Anu 22 9000 402 Shane 29 8000 403 Rohan 34 6000 404 Scott 44 10000 405 Tiger 35 8000 write a simple SQL query to display the record for...

Consider the followingEmptable,

1. write a simple SQL query to display the record for studentin ascending order of thesalary.


2. write a simple SQL query to display the record for studentin descending order of thesalary.


3. write a simple SQL query to return records wheresalaryis less than10000 andage greater than25.


4. write a simple SQL query to return return records whereeithersalary is greater than 10000or age is greater than 25.


5. write a simple SQL query to return return records age 30 to 40