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.
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.
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.
Showing 5 challenges · easy · 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.