sqlite
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 …
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 …
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 …
All SQLite Aggregate Functions statement with an example
All SQLite Aggregate Functions statement with an example: The following exercise will help you to improve your SQLite query skills …
Write a query to get the average admission fee for all branches containing more than 1 students
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the difference between the highest and lowest adminssion fee
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the number of students with the same branch
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the highest, lowest, sum, and average admission fee of all students
Introduction Write a query to get the highest, lowest, sum, and average admission fee of all students The following exercise …
Write a query to get the total admission fee from student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to list the number of Branches available in the student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the maximum admission fee of an student studying in Information technology branch
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the average admission fee and number of students studying in the Chemical engineering
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
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
Introduction Write a query to display the Full name, Branch, and fee for all students whose branch id is 200 …
Write a query to display the first name of all students who have both an “a” and “e” in their first name
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
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
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
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
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
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
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to display the full name, Admission Fee and scholarship (15% of Admission Fee) of all students
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to display the first names of students having ‘a’ as the 2nd character
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to display the first names of students whose names have exactly 6 characters
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get nth max admission fee of student
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get 4 minimum admission fees
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get 4 maximum admission fees
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to select last 5 records from a table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to find the 4th minimum admission fee in the student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to find the 5th maximum admission fee in the student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
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’
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to find the student names, admission fee, whose admission fee is greater than the average admission fee
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the length of the students names from student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get monthly fee of each and every student
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to calculate 401*14+1025-500
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the first 3 characters of first name from student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the Fullname from student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get first name from students table after removing white spaces from both side
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the total admission fee from student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the number of students studying in the college
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the number of students studying in the college
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get the number of unique branch available in the student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
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)
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get unique branch ID from student table
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get all students details from tbl_student table order by first name, ascending
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to get all students details from tbl_student table order by first name, descending
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
Write a query to display the Student names (first_name, last_name) using alias name “First Name”, “Last Name”
Introduction The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for …
