Seagull

Client-side SQL practice lab for students.

Home

IT EN

Choose an exercise, run SQL directly in your browser, and validate your result instantly.

Available exercises

Lesson 3

1. First query on the databaseNot completed
Open exercise
2. Select b and aNot completed
Open exercise
3. Calculate a + 10Not completed
Open exercise
4. Calculate differenceNot completed
Open exercise
5. Full SELECT on studentsNot completed
Open exercise
6. Books with SQL in the titleNot completed
Open exercise
7. Books starting with ZigNot completed
Open exercise
8. Books with 4 characters then JavaNot completed
Open exercise
9. Sort esercizi_base by aNot completed
Open exercise
10. Sum a+b in descending orderNot completed
Open exercise
11. Sort book_stars by user_id and voteNot completed
Open exercise
12. Count StudentsNot completed
Open exercise
13. Candidates with Python, Power BI, and SQLiteNot completed
Open exercise
14. How many books are about Java or PythonNot completed
Open exercise
15. Average user voteNot completed
Open exercise
16. Duplicate titlesNot completed
Open exercise
17. Most used titleNot completed
Open exercise
18. Top 3 albums by track countNot completed
Open exercise
19. Top 10 artists by track countNot completed
Open exercise
20. Total active time in 2025Not completed
Open exercise
21. Total stop time by month and machine IDNot completed
Open exercise
22. Top 10 days by total pause timeNot completed
Open exercise
23. How many different Netflix titles I watchedNot completed
Open exercise
24. How many days I watched NetflixNot completed
Open exercise
25. Which days I watched Squid GameNot completed
Open exercise
26. Day with the most content watchedNot completed
Open exercise
27. Year with the most content watchedNot completed
Open exercise
28. Netflix shows watched more than onceNot completed
Open exercise
29. Netflix show with the longest titleNot completed
Open exercise
30. Open answer: primary keyNot completed
Open exercise

Lesson 4

1. Create user TableNot completed
Open exercise
2. Create student TableNot completed
Open exercise
3. Create order Table with FKNot completed
Open exercise
4. Create score TableNot completed
Open exercise
5. Create course TableNot completed
Open exercise
6. Create student-course m2m RelationshipNot completed
Open exercise
7. Create easy_pearson_book TableNot completed
Open exercise
8. Create current_oee TableNot completed
Open exercise
9. Insert student rowsNot completed
Open exercise
10. Insert course rowsNot completed
Open exercise
11. Insert student-course rowsNot completed
Open exercise
12. Update a student rowNot completed
Open exercise
13. Delete a student rowNot completed
Open exercise
14. Drop order tableNot completed
Open exercise

Lesson 5

1. Average total_pieces per machineNot completed
Open exercise
2. Books without votes with book_id and nameNot completed
Open exercise
3. Recommendation by publisher and keywordNot completed
Open exercise
4. Total amount spent by each customerNot completed
Open exercise
5. Visit days by customerNot completed
Open exercise
6. First menu item purchased by each customerNot completed
Open exercise
7. Most purchased menu itemNot completed
Open exercise
8. Items and spending before membershipNot completed
Open exercise
9. Points per customer with sushi bonusNot completed
Open exercise
10. Number of unique nodesNot completed
Open exercise
11. Number of nodes per regionNot completed
Open exercise
12. Customers assigned to each regionNot completed
Open exercise
13. Unique count and amount by transaction typeNot completed
Open exercise
14. OEE for each machineNot completed
Open exercise

Lesson 8

1. Complete workflow on devices/equipmentNot completed
Open exercise
2. Subquery: book_id rated 4 by user 550Not completed
Open exercise
3. Books without votes using a subqueryNot completed
Open exercise
4. Count watched episodes for two showsNot completed
Open exercise
5. Total votes with a correlated subqueryNot completed
Open exercise
6. Netflix counts by year with a CTENot completed
Open exercise
7. Top Netflix year and content watched per monthNot completed
Open exercise
8. UPDATE Trigger for Email and PhoneNot completed
Open exercise
9. AFTER INSERT Trigger on UsersNot completed
Open exercise
10. AFTER DELETE Trigger on UsersNot completed
Open exercise
11. Update updated_at with a triggerNot completed
Open exercise
12. Drop an UPDATE triggerNot completed
Open exercise
13. Inspect triggers with sqlite_masterNot completed
Open exercise
14. Create a View with All Pearson BooksNot completed
Open exercise
15. View of Books Without Votes and Test with Invented BooksNot completed
Open exercise
16. View of the Top 10 Books by Total VotesNot completed
Open exercise
17. Drop the Pearson books viewNot completed
Open exercise
18. Users with the fewest voting daysNot completed
Open exercise
19. Monthly balance by customerNot completed
Open exercise

Lesson 9

1. Read a Redis valueNot completed
Open exercise
2. Store a Redis valueNot completed
Open exercise
3. Simple key-value cacheNot completed
Open exercise
4. Remove a sessionNot completed
Open exercise
5. Key-value databasesNot completed
Open exercise
6. Key-value limitsNot completed
Open exercise
7. Document vs key-valueNot completed
Open exercise
8. Column-oriented databasesNot completed
Open exercise
9. Graph databasesNot completed
Open exercise
10. ShardingNot completed
Open exercise
11. ReplicationNot completed
Open exercise
12. Write-write conflictsNot completed
Open exercise
13. CAP theoremNot completed
Open exercise
14. Eventual consistencyNot completed
Open exercise
15. Extra: page view counterNot completed
Open exercise
16. Extra: build a listNot completed
Open exercise
17. Extra: read a listNot completed
Open exercise
18. Extra: unique tags with setsNot completed
Open exercise
19. Extra: read a setNot completed
Open exercise
20. Extra: profile with hashesNot completed
Open exercise
21. Extra: read a hash fieldNot completed
Open exercise

Lesson 10

1. MongoDB age filterNot completed
Open exercise
2. JSON and BSONNot completed
Open exercise
3. Flexible schemaNot completed
Open exercise
4. Collections and documentsNot completed
Open exercise
5. _id field and ObjectIdNot completed
Open exercise
6. Embedded document or referenceNot completed
Open exercise
7. Large one-to-many relationshipsNot completed
Open exercise
8. Reverse referenceNot completed
Open exercise
9. Comparison operatorsNot completed
Open exercise
10. Projection in findNot completed
Open exercise
11. Indexes and aggregationsNot completed
Open exercise