How to add your own SQL Coding Questions to the Library?

  1. Log In to Your Account


  1. Navigate to the Library Tab
  • In the sidebar, click Library.
  • Or click My Library in the top bar.


  1. Create an SQL Coding Question
  • Click the Create Question button in the top-right corner.**
  • From the dropdown, select Create SQL Question.



  1. Add Problem Information
  • Choose the relevant domain for your SQL question.
  • Specify whether the question is Easy, Medium, or Hard.
  • Enter an appropriate title for the question.



  • Enter the problem statement for your SQL question in the question statement section.



  1. Configure the SQL Instance
  • Choose the appropriate question type (e.g., "Select" for queries like SELECT * FROM…).
  • Tick the checkbox (Validate Column Names as well) if you want column names to be validated.
  • Click + Add Table.
  • Enter the table name and define all column names along with their configurations.


Use the following column attributes based on your requirements:


Attribute

Description

AI (Auto Increment)

Automatically increments the value for each new row inserted.

ZF (Zero Fill)

Pads numeric values with leading zeros.

US (Unsigned)

Allows only non-negative numeric values.

 NN (Not Null)

Ensures the column cannot contain NULL values.

PK (Primary Key)

Uniquely identifies each row in the table.


Note: Every table must have at least one column designated as a Primary Key.


  1. Validate the Table Schema
  • Click Check Table(s) to validate the schema.
  • Confirm that No Errors appears next to the button.
  • To add more tables, click + Add Table again.
  • To remove the last table, click + Remove Last Table.



  1. Add Queries for Your Question
  • Add your table's insert query and answer query.
  • To demonstrate the SQL functionality, add sample records to your table.


Sample Record #1:


Sample Record #2:


Sample Record #3:


Note: You must add three different sample records, as these are used as test cases for the question.


  1. Write Your Answer Query
  • Write the query that retrieves the desired information from the table based on the problem statement.



  • Once configured, click Execute Answer Query to verify the results.



  1. Save the Question
  • Verify that the table schema has been validated and that the answer query returns the expected results before saving.
  • Click Save Question.


Note: Before saving, always ensure the table schema has been checked and the answer query produces the correct results when executed.


Updated on: 04/17/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!