All SQLite Basic Subquery Statements with example

The following exercise will help you to improve your SQLite query skills effectively. I have used BD Browser for sqlite for following exercise.

1. Write a query to find the student names, admission fee, whose admission fee is greater than the average admission fee
2. Write a query to find the full name and fee of the students who have a higher salary than the student whose last_name=’smith’
3. Write a query to find the 5th maximum admission fee in the student table
4. Write a query to find the 4th minimum admission fee in the student table
5. Write a query to select last 5 records from a table
6. Write a query to get 4 maximum admission fees
7. Write a query to get 4 minimum admission fees
8. Write a query to get nth max admission fee of student