Choose an exercise, run SQL directly in your browser, and validate your result instantly.
Available exercises
Lesson 3
- First query on the databaseNot completedOpen exercise
- Select b and aNot completedOpen exercise
- Calculate a + 10Not completedOpen exercise
- Calculate differenceNot completedOpen exercise
- Full SELECT on studentsNot completedOpen exercise
- Books with SQL in the titleNot completedOpen exercise
- Books starting with ZigNot completedOpen exercise
- Books with 4 characters then JavaNot completedOpen exercise
- Sort esercizi_base by aNot completedOpen exercise
- Sum a+b in descending orderNot completedOpen exercise
- Sort book_stars by user_id and voteNot completedOpen exercise
- Count StudentsNot completedOpen exercise
- Candidates with Python, Power BI, and SQLiteNot completedOpen exercise
- How many books are about Java or PythonNot completedOpen exercise
- Average user voteNot completedOpen exercise
- Duplicate titles and most used titleNot completedOpen exercise
- Users with the fewest voting daysNot completedOpen exercise
- Top 3 albums by track countNot completedOpen exercise
- Top 10 artists by track countNot completedOpen exercise
- Total active time in the latest available yearNot completedOpen exercise
- Total stop time by month and machineNot completedOpen exercise
- Top 10 days by total pause timeNot completedOpen exercise
- OEE for each machineNot completedOpen exercise
- How many different Netflix titles I watchedNot completedOpen exercise
- How many days I watched NetflixNot completedOpen exercise
- Which days I watched Squid GameNot completedOpen exercise
- Day with the most content watchedNot completedOpen exercise
- Year with the most content watchedNot completedOpen exercise
- Netflix shows watched more than onceNot completedOpen exercise
- Netflix show with the longest titleNot completedOpen exercise
Lesson 4
- Create user TableNot completedOpen exercise
- Create student TableNot completedOpen exercise
- Create order Table with FKNot completedOpen exercise
- Create score TableNot completedOpen exercise
- Create course TableNot completedOpen exercise
- Create student-course m2m RelationshipNot completedOpen exercise
- Create easy_pearson_book TableNot completedOpen exercise
- Create current_oee TableNot completedOpen exercise
Lesson 5
- Average total_pieces per machineNot completedOpen exercise
- Books without votes with book_id and nameNot completedOpen exercise
- Recommendation by publisher and keywordNot completedOpen exercise
- Total amount spent by each customerNot completedOpen exercise
- Visit days by customerNot completedOpen exercise
- First menu item purchased by each customerNot completedOpen exercise
- Most purchased menu itemNot completedOpen exercise
- Items and spending before membershipNot completedOpen exercise
- Points per customer with sushi bonusNot completedOpen exercise
- Number of unique nodesNot completedOpen exercise
- Number of nodes per regionNot completedOpen exercise
- Customers assigned to each regionNot completedOpen exercise
- Unique count and amount by transaction typeNot completedOpen exercise
- Monthly closing balance by customerNot completedOpen exercise
Lesson 10
- Complete workflow on devices/equipmentNot completedOpen exercise
- Subquery: book_id rated 4 by user 550Not completedOpen exercise
- Books without votes using a subqueryNot completedOpen exercise
- Count watched episodes for two showsNot completedOpen exercise
- Top Netflix year and content watched per monthNot completedOpen exercise
- UPDATE Trigger for Email and PhoneNot completedOpen exercise
- AFTER INSERT Trigger on UsersNot completedOpen exercise
- AFTER DELETE Trigger on UsersNot completedOpen exercise
- Update updated_at with a triggerNot completedOpen exercise
- Create a View with All Pearson BooksNot completedOpen exercise
- View of Books Without Votes and Test with Invented BooksNot completedOpen exercise
- View of the Top 10 Books by Total VotesNot completedOpen exercise