Data Dungeon
← All sections

Section 5

The Fractured Loom

Warp and weft — stitch subqueries into woven chains.

Floors 21–25 · 14 chambers · 6325 XP

Floor 21

Warp Hall

…
  1. Chamber 61Locked

    Warp Thread

    WITH names a step

    WITHWHERE
    +395 XPPreview →
  2. Chamber 62Locked

    Weft Count

    Scalar subquery per row

    SubqueryCOUNT
    +405 XPPreview →
  3. Chamber 63Locked

    Anchor Thread

    Filter inside a CTE

    WITHWHERE
    +415 XPPreview →

Floor 22

Loom Gallery

…
  1. Chamber 64Locked

    Double Weave

    CASE in a second CTE

    WITHCASE
    +420 XPPreview →
  2. Chamber 65Locked

    Gallery Join

    DISTINCT in a CTE

    WITHDISTINCTINNER JOIN
    +430 XPPreview →
  3. Chamber 66Locked

    Tangled Join

    CTE + wing filter

    WITHINNER JOIN
    +440 XPPreview →

Floor 23

Tangled Archives

…
  1. Chamber 67Locked

    Archive Totals

    CTE + GROUP BY

    WITHINNER JOINGROUP BY
    +445 XPPreview →
  2. Chamber 68Locked

    Corridor Whisper

    Correlated EXISTS

    EXISTSSubquery
    +455 XPPreview →
  3. Chamber 69Locked

    Pattern Threshold

    HAVING inside a CTE

    WITHGROUP BYHAVING
    +465 XPPreview →

Floor 24

Pattern Vault

…
  1. Chamber 70Locked

    Vault Derived

    Subquery in FROM

    SubqueryINNER JOINAVGGROUP BY
    +470 XPPreview →
  2. Chamber 71Locked

    Mirror Weave

    CTE + LEFT JOIN

    WITHLEFT JOINCOALESCEGROUP BY
    +480 XPPreview →
  3. Chamber 72Locked

    Fracture Standing

    Window on a CTE

    WITHWindowORDER BY
    +490 XPPreview →

Floor 25

Weaver's Seal

…
  1. Chamber 73Locked

    Weaver Prelude

    CTE + COALESCE + IN

    WITHCOALESCEIN
    +495 XPPreview →
  2. Section Boss
    Chamber 74Locked

    Loom Weaver

    Close the Fractured Loom

    BossWITHWindowEXISTSINNER JOINGROUP BYORDER BY
    +520 XPPreview →