All SQLite Basic Select Statements with example

If you have been working with other database management systems such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL then you must have heard about SQLite. The following exercise will help you to improve your SQLite query skills effectively. I have used db browser for sqlite for following exercise.

1. Write a query to display the Student names (first_name, last_name) using alias name “First Name”, “Last Name”
2. Write a query to get all students details from tbl_student table order by first name, descending
3. Write a query to get all students details from tbl_student table order by first name, ascending
4. Write a query to get unique branch ID from student table
5. Write a query to get the names (first_name, last_name), admission_fess, Scholarship of all the students(Scholarship is calculated as 10% of admission_fess)
6. Write a query to get the number of unique branch available in the student table
7. Write a query to get the number of students studying in the college
8. Write a query to get the average Scholarship and number of students in the student table
9. Write a query to get the total admission fee from student table
10. Write a query to get first name from students table after removing white spaces from both side
11. Write a query to get the Fullname from student table
12. Write a query to get the first 3 characters of first name from student table
13. Write a query to calculate 401*14+1025-500
14. Write a query to get monthly fee of each and every student
15. Write a query to get the length of the students names from student table