PostgreSQL Queries (Online Practice) | Exercise Set | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

29/32 Salary category for each employee

1. Introduction

2. Get to know the artist table

3. Get to know the museum table

4. Get to know the piece_of_art table

5. Placement of pieces of art

6. Works of artists from 19th century and later

7. List all pieces of art

8. Legacy of unknown artists

9. Artists' productivity

10. Get to know the band_members table

11. Bands' members and their leaders

12. How many members does each band have?

13. Get to know the categories table

14. Get to know the products table

15. Tallying the products in each category

16. Get to know the clients table

17. Get to know the orders table

19. Get to know the order_items table

20. Check a certain order

21. Revenue for each order

22. How much money did each client spend per category?

23. Ranking categories by sales

24. Who repurchased products?

25. Get to know the employee table

26. Get to know the salgrade table

27. Get to know the benefits table

28. From rags to riches

29. Salary category for each employee

30. Benefits of one employee

31. Benefit usage count

32. Congratulations

Good! Only three more exercises left!

Select the first name, last name, salary and salary grade of employees whose salary fits between the lower_limit and upper_limit from the salgrade table.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.