THE CODING CALENDAR / LEARN BY DOING

One concept.
Make it work.

A little documentation. A real-world problem. Your code, running right here. Find today’s challenge or revisit a skill from the archive.

JavaScript · Python · SQLNo account neededRuns on your device

TODAY

Calendar dates follow America/New_York.
Today:

Use Tab to reach the language tabs, Left/Right Arrow to choose one, and Enter or Space to open it.

JS

JavaScript

Arrays & sequences · Intermediate

Array.with()

with returns a new array replacing one indexed item while keeping the receiver unchanged.

Open challenge ↗

KEEP EXPLORING

The lesson archive.

147 matching published lessons.
Older challenges stay available.

Clear filters
Published challenges by date, language, topic, and difficulty
DateJavaScriptPythonSQL (SQLite)
Array.with()Arrays & sequences · Intermediatemath.isclose()Numbers & validation · IntermediateSUM() OVER with ROWS frameTotals & groups · Intermediate
Array.findLast()Arrays & sequences · Intermediateitertools.accumulate()Totals & groups · IntermediateNOT EXISTSJoining data · Intermediate
Array.flat()Arrays & sequences · Beginnercollections.CounterObjects & dictionaries · IntermediateWITH common table expressionTotals & groups · Intermediate
Object.hasOwn()Objects & dictionaries · Intermediatestr.partition()Strings & text · IntermediateLAG()Selecting & sorting · Intermediate
Array.toReversed()Arrays & sequences · Intermediatedict.fromkeys()Objects & dictionaries · BeginnerCOUNT(DISTINCT expression)Totals & groups · Intermediate
Array.toSorted()Arrays & sequences · Intermediatedict.setdefault()Objects & dictionaries · IntermediateEXISTSJoining data · Intermediate
String.replaceAll()Strings & text · Beginnerdict.items()Objects & dictionaries · IntermediateROW_NUMBER()Selecting & sorting · Intermediate
Object.fromEntries()Objects & dictionaries · Intermediateall()Conditions & missing values · IntermediateUNION ALLSelecting & sorting · Intermediate
Array.findIndex()Arrays & sequences · Beginnerany()Conditions & missing values · BeginnerNULLIF()Conditions & missing values · Beginner
Array.sort()Arrays & sequences · Beginnersum()Numbers & validation · BeginnerCASEConditions & missing values · Beginner
Object.entries()Objects & dictionaries · Beginnerzip()Arrays & sequences · BeginnerLEFT JOINJoining data · Intermediate
Array.every()Arrays & sequences · Beginnerenumerate()Arrays & sequences · BeginnerHAVINGTotals & groups · Intermediate
Array.flatMap()Arrays & sequences · Beginnersorted()Arrays & sequences · BeginnerCOALESCE()Conditions & missing values · Beginner
Array.includes()Arrays & sequences · Beginnerstr.replace()Strings & text · BeginnerINNER JOINJoining data · Intermediate
Array.some()Arrays & sequences · Beginnerstr.startswith()Strings & text · BeginnerORDER BY + LIMITSelecting & sorting · Beginner
Array.find()Arrays & sequences · Beginnerdict.get()Objects & dictionaries · BeginnerAVG()Totals & groups · Beginner
Array.reduce()Arrays & sequences · Beginnerstr.join()Strings & text · BeginnerCOUNT(*)Totals & groups · Beginner
Array.map()Arrays & sequences · Beginnerstr.strip()Strings & text · BeginnerSUM() + GROUP BYTotals & groups · Intermediate
Array.filter()Arrays & sequences · Beginnerstr.split()Strings & text · BeginnerWHEREConditions & missing values · Beginner
Number.isFinite()Numbers & validation · Beginnerlist.count()Arrays & sequences · BeginnerIS NULLConditions & missing values · Beginner

The calendar opens on the actual current date. Older lessons stay organized by topic, language, difficulty, and month; upcoming dates show when their challenges will open.