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.
Showing 4 challenges · easy
Guide: free Python coding challenges
Practice Python by solving problems
PythonSkillset challenges are hands-on coding exercises from beginner to advanced. Open a challenge, read the problem, write Python in the split-pane editor, and run tests with Pyodide — no install required.
How to use the arena
- Pick a category — basics, algorithms, strings, and more
- Open a challenge, read the statement, and edit the starter code
- Run tests, fix failures, then try a related quiz or tutorial lesson
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.