Python coding challenges: "with"

All Easy Medium Hard

All Python Basics Strings & Text Lists & Arrays Dicts & Sets Functions & Closures OOP & Classes Data Structures & Algorithms Advanced Python Iterators & Generators Decorators & Context Managers Error Handling & Exceptions Regular Expressions Math & Number Theory Bit Manipulation Dynamic Programming Trees & Binary Trees Graphs & Graph Algorithms Recursion & Backtracking Greedy Algorithms Binary Search Two Pointers & Sliding Window Stacks & Queues Heaps & Priority Queues Linked Lists Matrix & 2D Arrays Datetime & Time Calculations Data Formats & Parsing SQL & SQLite Numpy & Vectorized Computing Cryptography & Hashing

SQL & SQLite easy

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.

sqlite schema table

+8 pts 10m

SQL & SQLite easy

Customers Never Order

Given Customers and Orders tables, return the names of customers with no orders, sorted alphabetically, or None if all have ordered.

sql sqlite join

+10 pts 15m

Showing 2 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.

Python Coding Challenges

Create Table Schema

Customers Never Order

SQL & SQLite — Python coding challenges

What you will find here

Challenges vs tutorials and quizzes

Python Coding
Challenges