SQL code copied to buffer
Choose login method
X
Login on the site is only required to save your progress. You can continue testing without logging into the site.
Sharpen your SQL skills with our interactive exercises and assessments!
Practice a wide range of SQL tasks, from basic queries to advanced techniques. Get immediate feedback on your solutions, helping you learn from mistakes and improve your skills. Boost your confidence for job interviews and real-world SQL applications.
Practice a wide range of SQL tasks, from basic queries to advanced techniques. Get immediate feedback on your solutions, helping you learn from mistakes and improve your skills. Boost your confidence for job interviews and real-world SQL applications.
Group tasks by:
Project's tough.
- 1. What is SQL?
- 2. What is DBMS?
- 3. What is RDBMS?
- 4. What is a Database?
- 5. What is ACID?
- 6. What is a subset of the SQL language?
- 7. What are DDL commands?
- 8. What are DQL commands?
- 9. What are DML commands?
- 10. How is data structured in a relational database?
- 11. What is index in SQL?
- 12. Index usage
- 13. What is a covering index?
- 14. Using a covering index
- 15. What is a constraint in SQL?
- 16. What is a primary key?
- 17. SQL constraints types
- 18. SQL tables joins types
- 19. Choose join type
- 20. Choose tables join type
- 21. Order of execution of logical operators
- 22. SQL set operators
- 23. Difference between UNION and UNION ALL
- 24. How to find common rows in SQL?
- 25. What relation types exists in SQL?
- 26. Determine the type of relationship
- 27. What is a view in SQL?
- 28. What is a materialized view?
- 29. How avoid accidental deletion?
- 30. What is a SQL transaction?
- 31. What is normalization in SQL?
- 32. What is a subquery?
- 33. What is a correlated subquery?
- 34. What is "PIVOT" in SQL?
- 1. Get the actors
- 2. Sort the penguins
- 3. Find addresses without postal code
- 4. Get the ordered list of languages
- 5. Get list of actors names
- 6. Get the languages list
- 7. Get an ordered list of movies
- 8. Get list of clients
- 9. Get a list of movie ratings
- 10. Get the sorted list of films with limit
- 11. Get the first 10 movies in alphabetical order
- 12. Get films list third page
- 13. Get a list of movies sorted by multiple fields
- 14. Get the longest movie
- 15. Find long movies
- 16. Find stuff members by condition
- 17. Find active customers
- 18. Find the actors by name
- 19. Find film names by description
- 20. Get the sorted list of films with condition
- 21. Find long comedies
- 22. Select clients without the letter "A"
- 23. Find adult only films about Database Administrator
- 24. Find films about Dogs or Cats
- 25. Get list of restricted films
- 26. Get the restricted films list
- 27. Find employees works on the project
- 28. Find foreign employees
- 29. Find employees by hire date
- 30. Find films with no available inventory
- 31. Find languages not represented in films
- 32. Get a list of movies and their categories
- 33. Extract address and domain from email
- 34. Get table columns data
- 35. Get list of indexes
- 36. Movies without cast records
- 37. Clients whose first name is the last name of another client
- 38. Find clients who have met each other
- 39. Find movies that have never been rented
- 40. Find films in several categories
- 41. Customers with matching name initials
- 42. Find rented films
- 1. Calculate circle perimeter
- 2. Calculate the area of a circle
- 3. Find the hypotenuse of a triangle
- 4. Calculate factorial
- 5. Generate a list of movies in JSON format
- 6. Find an addresses with even postal codes
- 7. Build a overal email list
- 8. Generate monthly bill
- 9. Build shared surnames list
- 10. Find the palindrome names
- 11. Output a list of customer names
- 12. Calculate the tax
- 13. Get formatted list of films
- 14. Find the tomorrow date
- 15. Find the first and last dates of month
- 16. Find the first and last dates of week
- 1. Find the average length of a movie
- 2. Find the minimal and maximal film rental cost
- 3. Find film average rental time
- 4. Find the number of employees
- 5. Find the number of films in each category
- 6. The average cost of renting a movie by category
- 7. Find minimum, maximum and average film duration
- 8. Find long movie categories
- 9. Find the least popular movies
- 10. Find the top spending customers
- 11. Average film rental duration for each customer
- 12. Analyze monthly payment
- 13. Find movie distribution by store
- 14. Find valuable employees
- 15. Find the salary ratio
- 16. Quarterly earnings analysis
- 17. Find the countries with the most customers
- 18. Find the count of rented disks
- 19. Find the number of returns
- 20. Get a list of actors - namesakes
- 21. Get movie cast lists
- 22. Find all the actors in the film
- 23. Analyze weekly rentals
- 24. Find repeat rentals
- 25. Find movies available in one store only
- 26. Find movies with no available copies
- 27. Distribution of films by categories in JSON format
- 28. Find a February 2006 hit
- 29. Find a 2005 hits
- 30. Analysis of the cost of film rental by category
- 1. Find addresses using sub-query
- 2. Clients who are not familiar with EMILY DEE films
- 3. Find movies with the highest replacement cost
- 4. Find movies with above-average rental rates
- 5. Find clients with a high number of rentals
- 6. Find movies with rental time below average
- 7. Movies without actors records
- 8. Find all actors never starred in adult only films
- 1. Movie rental prices by category
- 2. Get rolling payment amounts
- 3. Find average disk idle time
- 4. Find the distribution by categories
- 5. Get list of highly paid employees
- 6. Create a salary rating
- 7. Find movie popularity rating
- 8. Find customer details
- 9. Find EMILY DEE fans
- 10. Find movies with the highest replacement cost
- 11. Find the Horror films fans
- 1. Find the average client activity time
- 2. Find the average revenue
- 3. Find the store average revenue
- 4. Analyze customer payments
- 5. Analyze monthly payment
- 6. Analyze monthly payments (2)
- 7. Find movie popularity rating
- 8. Find the count of rented disks
- 9. Find the number of returns
- 10. Disc rental and return statistics
- 11. Count the rental delays
- 12. Calculate the percentage of delays
- 13. Find the most diverse clients
- 14. Daily income by source
- 15. Find acting duets
- 16. Find film distribution
- 17. Find films that were out of stock
- 18. Payments analyze
- 19. Improve payments analyze
- 20. Distribution of clients by weekday
- 21. Improve distribution of clients by weekday
- 22. Find the distribution of clients by time of day
- 23. Find never been delayed films
- 24. Find most delayed films
- 25. Staff performance analysis
- 26. Category popularity analysis
- 27. Gap & Islands problem
- 28. Find customers who sow same films
- 29. Get a list of no-show passengers
- 30. Find average flight occupancy
- 31. Find flight occupancy by fare
- 32. Find the median salary
- 33. Find the median booking amount
- 34. Find the median film's length
- 1. Create new address record
- 2. Update the postal code
- 3. Enter Woodridge postal code
- 4. Update Canadian postal codes
- 5. Enter new staff record
- 6. Create customer addresses view
- 7. Penguins stats
- 8. Remove customer records
- 9. Create department table
- 10. Alter the staff table
- 11. Perform price update
- 12. Update customer's address
- 13. Adjust the rental cost
- 14. Update replacement cost
- 15. Move film between categories
- 16. Penguins stats table
- 17. Actual statistics
- 18. Actual statistics 2
Help make SQLtest.online even better!
Greetings, SQL lovers!
I am writing to you today because I need your help.
SQLtest.online is a free platform designed to help people of all levels master SQL.We offer a wide range of interactive tests, problems and training materials to help you improve your SQL skills.
The platform has already helped a lot of people, but we want to make it even better. And this is where you can help us!
How you can help:
- Invite your friends and colleagues to join SQLtest.online!
- Tell your friends and colleagues about SQLtest.online. Share a link to our site on social networks, by email or in person.
- Write an article or blog post about SQLtest.online. Share your experience with the platform.
- Together we can make SQLtest.online the best resource for learning SQL!
The more people use the platform, the better it will become. We'll be able to add more content, improve features, and create a better community for SQL enthusiasts.
Thanks for your help!
Command SQLtest.online
Explore over 310 diverse tasks on our platform.
To keep the penguins_by_islands table (created in this task) up to date, you need to write a trigger that fires after rows are added to the penguins table. The trigger code should update the number of penguins in the corresponding record of the resulting table, or create a new record if a penguin is added for an island that is not yet in the table.
Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.
Write your request in the field below and click the "Check it!" button.
Get hint
Copy code
Clear editor
Querynomicon (SQLite)
A compact database for learning the basics of SQL.The Querynomicon database contains tables:
little_penguins - table of little penguins.
- speciesPenguin species.
- islandIsland of residence.
- bill_length_mmBill length, mm.
- bill_depth_mmBill depth, mm.
- flipper_length_mmFlipper length, mm.
- body_mass_gBody mass, g.
- sexSex.
| species | island | bill_length_mm | bill_depth_mm | flipper_length_mm | body_mass_g | sex |
|---|---|---|---|---|---|---|
| Gentoo | Biscoe | 52.1 | 17 | 230 | 5550 | MALE |
penguins - table of penguins.
- speciesPenguin species.
- islandIsland of residence.
- bill_length_mmBill length, mm.
- bill_depth_mmBill depth, mm.
- flipper_length_mmFlipper length, mm.
- body_mass_gBody mass, g.
- sexSex.
| species | island | bill_length_mm | bill_depth_mm | flipper_length_mm | body_mass_g | sex |
|---|---|---|---|---|---|---|
| Gentoo | Biscoe | 52.1 | 17 | 230 | 5550 | MALE |
staff - table of employees.
- identEmployee number.
- personalEmployee first name.
- familyEmployee last name.
- deptDepartment.
- ageAge.
| ident | personal | family | dept | age |
|---|---|---|---|---|
| 7 | Abram | Chokshi | gen | 23 |