w3resource logo


SQLite exercises

SQLite basic SELECT statement - Exercises, Practice, Solution

Secondary Nav

Basic SELECT statement [18 exercises with solution]

1. Write a query to display the names (first_name, last_name) using alias name "First Name", "Last Name" Go to the editor

Click me to see the solution

Sample table : employees

2. Write a query to get unique department ID from employee table. Go to the editor

Click me to see the solution

Sample table : employees

3. Write a query to get all employee details from the employee table order by first name, descending. Go to the editor

Click me to see the solution

Sample table : employees

4. Write a query to get the names (first_name, last_name), salary, PF of all the employees (PF is calculated as 12% of salary). Go to the editor

Click me to see the solution

Sample table : employees

5. Write a query to get the employee ID, names (first_name, last_name), salary in ascending order of salary. Go to the editor

Click me to see the solution

Sample table : employees

6. Write a query to get the total salaries payable to employees. Go to the editor

Click me to see the solution

Sample table : employees

7. Write a query to get the maximum and minimum salary from employees table. Go to the editor

Click me to see the solution

Sample table : employees

8. Write a query to get the average salary and number of employees in the employees table. Go to the editor

Click me to see the solution

Sample table : employees

9. Write a query to get the number of employees working with the company. Go to the editor

Click me to see the solution

Sample table : employees

10. Write a query to get the number of jobs available in the employees table. Go to the editor

Click me to see the solution

Sample table : employees

11. Write a query get all first name from employees table in upper case. Go to the editor

Click me to see the solution

Sample table : employees

12. Write a query to get the first 3 characters of first name from employees table. Go to the editor

Click me to see the solution

Sample table : employees

13. Write a query to calculate 171*214+625. Go to the editor

Click me to see the solution

14. Write a query to get the names (for example Ellen Abel, Sundar Ande etc.) of all the employees from employees table. Go to the editor

Click me to see the solution

Sample table : employees

15. Write a query to get first name from employees table after removing white spaces from both side. Go to the editor

Click me to see the solution

Sample table : employees

16. Write a query to get the length of the employee names (first_name, last_name) from employees table. Go to the editor

Click me to see the solution

Sample table : employees

17. Write a query to select first 10 records from a table. Go to the editor

Click me to see the solution

Sample table : employees

18. Write a query to get monthly salary (round 2 decimal places) of each and every employee? Go to the editor
Note : Assume the salary field provides the 'annual salary' information.

Click me to see the solution

Sample table : employees

 

... More

Structure of 'hr' database :

hr database



Join our Question Answer community to learn and share your programming knowledge.