You can make you own autograded SQL problems in Playlists. There are only a few steps to writing a good SQL program, and you can see a demo in the video below!
Create an assignment from Create page or Assignments page
Step 1: Create a SQL Exercise
Choose Coding Exercise > Select a SQL Program Type
Fill in assignment details: title, description, and starter code
Step 2: Add Data through Advanced Settings
Click edit next to your assignment
Click on Advanced Settings (bottom left)
Click the SQL Setup Code Tab
Add your data
Create an Assignment in a Playlist
Start by creating a playlist, and make a new activity. Choose SQL for the problem type.
Write a description describing what your students should query.
Load in Data in the SQL Setup Code tab by writing queries that generate a Database with your content.
Write the correct query in the Solution Code section of the Code tab.
Assign to your students! They'll be able to load the problem, start with the preloaded data, and write queries. The autograder will automatically check if their results match what your solution code produces.
Still have questions? Contact our team at email@example.com to learn more!