SQL code copied to buffer
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:
Support the project.
- 1. Get the actors
- 2. Get the languages list
- 3. Get list of actors names
- 4. Get the ordered list of languages
- 5. Get the sorted list of films with limit
- 6. Find stuff members by condition
- 7. Get the sorted list of films with condition
- 8. Find film names by description
- 9. Find the actors by name
- 10. Find the average length of a movie
- 11. Find foreign employees
- 12. Get an ordered list of movies
- 13. Find clients starting with the letter "A"
- 14. Find clients starting with the letter "A" (2)
- 15. Find the minimal and maximal film rental cost
- 16. Get the first 10 movies in alphabetical order
- 17. Find long movies
- 18. Calculate the area of a circle
- 19. Calculate circle perimeter
- 20. Find active customers
- 21. Find movies with above-average rental rates
- 22. Find movies with the highest replacement cost
- 23. Get list of clients
- 24. Analyze customer payments
- 25. Get a list of movie ratings
- 26. Get list of tables
- 27. Get table columns data
- 28. Get list of indexes
- 29. Get the restricted films list
- 30. Get list of restricted films
- 31. Find adult only films about Database Administrator
- 32. Create new address record
- 33. Update the postal code
- 34. Remove customer records
- 35. Find addresses without postal code
- 36. Find an addresses with even postal codes
- 37. Build shared surnames list
- 38. Get airports data
- 39. Find long-range aircraft
- 40. Find the palindrome names
- 41. What is SQL?
- 42. What is DBMS?
- 43. What is RDBMS?
- 44. What is a Database?
- 45. What is ACID?
- 46. What are DQL commands?
- 47. What is index in SQL?
- 48. SQL tables joins types
- 49. Choose join type
- 50. Perform price update
- 51. Update customer's address
- 52. Adjust the rental cost
- 53. Update replacement cost
- 54. Order of execution of logical operators
- 55. Difference between UNION and UNION ALL
- 56. Display a list of departments
- 57. Find employees by department
- 58. Find employee salary
- 59. Find employees with high salaries
- 60. Find employees with a salary above average
- 61. Find customers with even numbers
- 62. Find customers by phone prefix
- 63. Get unique customers list
- 64. How avoid accidental deletion?
- 65. What relation types exists in SQL?
- 66. Find non-Dollar/Euro countries
- 67. Jobs without specific requirements
- 68. Update project information
- 69. What is a subquery?
- 70. Root categories list
- 71. Product List
- 72. Filtered list of products
- 73. Ten heaviest products
- 74. Sort the penguins
- 75. Find light weight penguins
- 76. Penguins list
- 77. Distribution penguins by islands
- 78. Find small penguins
- 79. Find small penguins species
- 80. Search by pattern
- 81. Flipper length to body mass rate
- 82. Penguins whose sex is unknown
- 83. Heavy chinstrap penguins
- 84. Count the penguins
- 85. Penguins and Islands
- 86. Using a covering index
- 87. Find small penguins species
- 88. Penguins distribution
- 89. Common penguin species
- 90. Managed by Robert Nelson
- 91. Delete records
- 92. Delete employee records
- 93. Penguins stats
- 1. Find customers full names
- 2. Find addresses using sub-query
- 3. Find addresses using JOIN
- 4. Find duplicate actor names
- 5. Find the most popular surname among actors
- 6. Find all the actors in the film
- 7. Find all films of an actor
- 8. Find the distribution of films by category
- 9. Find the average length of a movie by category
- 10. Find the number of films in which the actor took part
- 11. Find actors more popular than HENRY BERRY
- 12. Analyze monthly payment
- 13. Find the best month
- 14. Find the most popular film
- 15. Analyze rental data for film
- 16. Find the department
- 17. Find employees works on the project
- 18. Find all customers with unshipped orders
- 19. Get a list of movies sorted by multiple fields
- 20. Get the longest movie
- 21. Get films list third page
- 22. Find the films never been rented
- 23. Find customers who did not return rented discs
- 24. Find average daily film rentals
- 25. Calculate daily income for the month
- 26. Generate dates table
- 27. Calculate the number of days off in a month
- 28. The average cost of renting a movie by category
- 29. Average film rental duration for each customer
- 30. Find long comedies
- 31. Find the distribution of customer activity
- 32. Find company stores details
- 33. Find clients who rented the film
- 34. Find minimum, maximum and average film duration
- 35. Find long movie categories
- 36. Find the number of employees
- 37. Find movie distribution by store
- 38. Find highly paid employees
- 39. Find employees by hire date
- 40. Get list of highly paid employees
- 41. Find valuable employees
- 42. Find the salary ratio
- 43. Find the average client activity time
- 44. Find the average revenue
- 45. Find the store average revenue
- 46. Create a salary rating
- 47. Quarterly earnings analysis
- 48. Find the countries with the most customers
- 49. Find customer details
- 50. Find the number of returns
- 51. Find the top spending customers
- 52. Find films with no available inventory
- 53. Find languages not represented in films
- 54. Find movies that have never been rented
- 55. Find clients with a high number of rentals
- 56. Find movies with the highest replacement cost
- 57. Count the rental delays
- 58. Calculate the percentage of delays
- 59. Extract address and domain from email
- 60. Get a list of actors - namesakes
- 61. Get a list of movies and their categories
- 62. Find film average rental time
- 63. Movie rental prices by category
- 64. Get rolling payment amounts
- 65. Find the number of films in each category
- 66. Find the most diverse clients
- 67. Find film distribution
- 68. Payments analyze
- 69. Distribution of clients by weekday
- 70. Find the distribution of clients by time of day
- 71. Improve distribution of clients by weekday
- 72. Movies without actors records
- 73. Movies without cast records
- 74. Find all the actors in the film
- 75. Find all actors never starred in adult only films
- 76. Analyze weekly rentals
- 77. Average rentals count
- 78. Find the distribution of clients by country
- 79. Find never been delayed films
- 80. Find most delayed films
- 81. Create department table
- 82. Find films about Dogs or Cats
- 83. Clients whose first name is the last name of another client
- 84. Update Canadian postal codes
- 85. Enter Woodridge postal code
- 86. Enter new staff record
- 87. Create customer addresses view
- 88. Distribution of films by categories in JSON format
- 89. Generate a list of movies in JSON format
- 90. Category popularity analysis
- 91. Build a overal email list
- 92. Select clients without the letter "A"
- 93. Alter the staff table
- 94. Find films in several categories
- 95. Get a list of airports
- 96. Find Boeing aircraft
- 97. Get flights departed from Domodedovo
- 98. Get a list of aircraft from Domodedovo
- 99. Aircraft usage analysis
- 100. Find last names with double letters
- 101. Customers with matching name initials
- 102. Output a list of customer names
- 103. Find the aircraft without Business class
- 104. Get counts of seats by class
- 105. Calculate the number of seats on flight
- 106. Get the list of destination airports
- 107. Get a list of airports with direct connections
- 108. Get a list of no-show passengers
- 109. Get a list of passengers
- 110. Find the flight delay
- 111. Get flights statistics
- 112. Rate airports
- 113. Find a list of flight options
- 114. Find the fastest flight
- 115. Calculate the daily number of flights
- 116. Get list of tables
- 117. Get information about the columns
- 118. Airports with one-way departures
- 119. Find airports relations
- 120. Find small airports
- 121. Get the passenger list
- 122. Get aircraft seat map
- 123. Get a list of planes in the air
- 124. What are DDL commands?
- 125. What are DML commands?
- 126. How is data structured in a relational database?
- 127. Choose tables join type
- 128. Calculate the tax
- 129. Get formatted list of films
- 130. What is a primary key?
- 131. Find the tomorrow date
- 132. Find the first and last dates of month
- 133. Find the first and last dates of week
- 134. Display a table of airports
- 135. Count departing passengers
- 136. Number of passengers with total
- 137. Display a table of departures
- 138. Get a list of airports with more than one direct flight
- 139. Show a sub-departments list (JOIN)
- 140. Get a list of sub-departments
- 141. Get list of tables (SQL Server)
- 142. Find duplicate phone numbers
- 143. What is a covering index?
- 144. What is a view in SQL?
- 145. Find a February 2006 hit
- 146. Get product category color counts
- 147. Find films to share
- 148. How to find common rows in SQL?
- 149. Orders shipped in the following month
- 150. Top states by population
- 151. Reduced salaries
- 152. List of categories
- 153. List of subcategories
- 154. What is a SQL transaction?
- 155. What is normalization in SQL?
- 156. What is a correlated subquery?
- 157. Create a phonebook
- 158. Staff availability report
- 159. What is "PIVOT" in SQL?
- 160. Film distribution by category and store
- 161. Determine the type of relationship
- 162. Find highly paid employees
- 163. Find the median salary
- 164. Find the hypotenuse of a triangle
- 165. Find the median booking amount
- 166. Find the median film's length
- 167. Prepare mailing list
- 168. Daily income by source
- 169. Penguins with absent data
- 170. Index usage
- 171. Island with the minimum penguins mass
- 172. The most populated island
- 173. Classic movies
- 174. Penguins stats table
- 175. Tables joining algorithms in SQL
- 176. Delete films records
- 177. Analyze bill length
- 178. Analyze flipper length
- 179. What is denormalization in RDB?
- 1. Find most active customers
- 2. Find sad actors
- 3. Find the most diverse actors
- 4. Find all films where HENRY BERRY did not participate
- 5. Calculate factorial
- 6. Find average disk idle time
- 7. Find the distribution by categories
- 8. Analyze monthly payments (2)
- 9. Find movie popularity rating
- 10. Find EMILY DEE fans
- 11. Clients who are not familiar with EMILY DEE films
- 12. Find the count of rented disks
- 13. Disc rental and return statistics
- 14. Find the least popular movies
- 15. Get movie cast lists
- 16. Find movies with rental time below average
- 17. Find acting duets
- 18. Find films that were out of stock
- 19. Improve payments analyze
- 20. Find repeat rentals
- 21. Find the Horror films fans
- 22. Find clients who have met each other
- 23. Find movies available in one store only
- 24. Find movies with no available copies
- 25. Staff performance analysis
- 26. Generate monthly bill
- 27. Find customers who sow same films
- 28. Get rows and seats count
- 29. Get a list of airports without direct connections
- 30. Find rented films
- 31. Obtain a list of passengers
- 32. Find average flight occupancy
- 33. Find flight occupancy by fare
- 34. FInd the plane coordinates
- 35. FInd the planes coordinates
- 36. What is a subset of the SQL language?
- 37. What is a constraint in SQL?
- 38. SQL constraints types
- 39. Get list of tables (PostgreSQL)
- 40. SQL set operators
- 41. Move film between categories
- 42. Find a 2005 hits
- 43. Analysis of the cost of film rental by category
- 44. What is a materialized view?
- 45. Distribution of flights by days of the week
- 46. Subcategories count
- 47. Actual statistics
- 48. 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
Based on the penguins table, create a view penguins_averages with the fields species - penguin species, sex - penguin sex, penguins_count - the number of individuals, and the fields avg_bill_length_mm, avg_bill_depth_mm, avg_flipper_length_mm and avg_body_mass_g - representing average values by species and sex of animals.
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
Explore over 320 diverse tasks on our platform.
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 |