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

Problem

LinkedIn's growth team wants to check how many customers have signed up so far this year. Are numbers up from last year? Is the pace on track? 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

Hints