Create custom SQL challenges

Create custom SQL challenges with your own data and provide a solution query

You can add a custom challenge to any assessment or interview. To create a custom challenge on Coderbyte, navigate to your custom challenge library by clicking Customization and then Custom Challenges.

Create SQL challenges

Under "Database" click Create.

After adding metadata, select from one of your SQL or MS SQL tables and upload a solution query that generates an output table like in the example below. 

Screen Shot 2022-10-02 at 3.54.35 PM

Once the table is generated you can click upload, and candidates will be expected to write a query such that their output matches the table you generated.

Your challenge can have the candidate query multiple tables, but you need to connect at least one main table to the challenge. Here is our guide on uploading custom databases.