Tech Study

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more

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 …

Read more