Menu
Coddy logo textTech

Recap - Membership

Part of the Beyond the Basics section of Coddy's SQL journey — lesson 19 of 27.

challenge icon

Challenge

Easy

Available tables and columns:

  • <strong>signup_2025</strong>: <strong>user_id</strong>
  • <strong>signup_2026</strong>: <strong>user_id</strong>

Return one column user_id containing the IDs of users who signed up in 2025 but not 2026: these are users who didn't renew. Order ascending.

Try it yourself

-- 2025 ids minus 2026 ids

All lessons in Beyond the Basics