Customers Who Signed Up This Year - Easy SQL Date Functions Interview Problem

LinkedIn's marketing team dashboard needs a new query: surface all customers who signed up this calendar year so the team can track acquisition pace against last year's numbers. 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 Input

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

Explanation

Bob signed up in 2023 and is excluded. Alice and Carol signed up in 2024, so they are returned with the most recent signup (Carol) appearing first.

Hints