Inner Join Two Tables
Write a function that inner joins two lists of dictionaries on a common key and returns the combined rows.
Create Table Schema
Write a function that creates a SQLite table with a given name and columns, and returns the resulting schema as a list of column definitions.
Index Creation Query
Create an in-memory SQLite database, execute CREATE INDEX statements, and return the resulting index metadata rows.
Second highest salary
Given an employees table, write a SQL query that returns the second highest distinct salary, or NULL if it doesn't exist.
Nth Highest Salary
Write a Python function using SQLite to return the Nth highest distinct salary from an employee table.
Customers Never Order
Given Customers and Orders tables, return the names of customers with no orders, sorted alphabetically, or None if all have ordered.
Cumulative Sum SQL
Write a SQL query to compute cumulative sales totals per product ordered by sale date.
Select All Users
Write a function that connects to an in-memory SQLite database and returns all users as a list of lists.
Add column alter
Write a function that connects to an in-memory SQLite database, creates a table, inserts rows, and adds a new column with ALTER TABLE.
Showing 1–9 of 9 challenges · SQL & SQLite
SQL & SQLite — Python coding challenges
What you will find here
This page lists sql & sqlite challenges — real Python problems you solve in the browser IDE with instant test feedback. Each challenge includes a clear brief, starter code, and automated checks.
Challenges vs tutorials and quizzes
Challenges test what you can build under constraints. For guided teaching, use our Python tutorials. For quick checks, try quizzes or copy snippets from code samples.