All SQLite Restricting & Sorting statement with example

All SQLite Restricting & Sorting statement 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 display the first names of students whose names have exactly 6 characters
2. Write a query to display the first names of students having ‘a’ as the 2nd character
3. Write a query to display the full name, Admission Fee and scholarship (15% of Admission Fee) of all students
4. Write a query to display the Full name and Admission Fee of all students whose Fee is not in the range 11,000 through 15,000
5. Write a query to display the Full name and Branch ID of all students in branch 300 or 600 in ascending order by branch ID
6. Write a query to display the Full name & admission fee for all students whose fee is not in the range 10,000 through 20,000 and are in branch 400 or 500
7. Write a query to display the first name of all students who have both an “a” and “e” in their first name
8. Write a query to display the Full name, Branch, and fee for all students whose branch id is 200 and 500, and whose fee is not equal to 10,000, 14,000, 23000