Customers Who Signed Up This Year

Problem

Growth teams track new customer acquisition by calendar year to measure whether marketing campaigns are driving sign-ups at the expected rate. Pulling all signups from the current year gives a baseline for year-over-year comparison reports and onboarding health checks. Using the customers table, return id, name, email, and created_at for customers whose created_at falls within the current year, ordered by created_at descending.

Schema

customers

column	type
id	INTEGER
name	TEXT
email	TEXT
created_at	DATE

Sample Data

id	name	email	created_at
1	Alice	alice@example.com	2024-03-10
2	Bob	bob@example.com	2023-11-05
3	Carol	carol@example.com	2024-07-22

Expected Output (if current year is 2024)

id	name	email	created_at
3	Carol	carol@example.com	2024-07-22
1	Alice	alice@example.com	2024-03-10