Customer Ages on 31 October 2025

Medium

Description

For every customer with a date of birth, show customer_id, date_of_birth, age_years (their age in whole years on 31 October 2025) and birthday (the day and month as text, such as 14 May).

Oldest first: end your query with ORDER BY age_years DESC, customer_id.

Tables

customers
customer_id (PK)
full_name
date_of_birth

customer_id	date_of_birth	age_years	birthday
10	1982-06-18T00:00:00.000Z	43	18 Jun
20	1984-01-29T00:00:00.000Z	41	29 Jan
8	1985-12-25T00:00:00.000Z	39	25 Dec
22	1986-04-16T00:00:00.000Z	39	16 Apr
16	1987-03-08T00:00:00.000Z	38	08 Mar
2	1988-11-02T00:00:00.000Z	36	02 Nov
12	1989-02-27T00:00:00.000Z	36	27 Feb
4	1990-07-30T00:00:00.000Z	35	30 Jul
17	1990-09-21T00:00:00.000Z	35	21 Sep
9	1991-04-05T00:00:00.000Z	34	05 Apr
1	1992-05-14T00:00:00.000Z	33	14 May
21	1992-06-06T00:00:00.000Z	33	06 Jun
23	1991-11-23T00:00:00.000Z	33	23 Nov
6	1993-01-17T00:00:00.000Z	32	17 Jan
15	1993-05-19T00:00:00.000Z	32	19 May
11	1994-08-11T00:00:00.000Z	31	11 Aug
3	1995-03-22T00:00:00.000Z	30	22 Mar
14	1996-10-03T00:00:00.000Z	29	03 Oct
18	1995-12-12T00:00:00.000Z	29	12 Dec
7	1997-09-09T00:00:00.000Z	28	09 Sep
25	1997-02-14T00:00:00.000Z	28	14 Feb
29	1996-12-30T00:00:00.000Z	28	30 Dec
19	1998-07-07T00:00:00.000Z	27	07 Jul
26	1999-08-19T00:00:00.000Z	26	19 Aug
27	2000-03-04T00:00:00.000Z	25	04 Mar

customers

customer_id (PK)

full_name

date_of_birth

customers

customer_id (PK)

full_name

date_of_birth

customer_id	date_of_birth	age_years	birthday
10	1982-06-18T00:00:00.000Z	43	18 Jun
20	1984-01-29T00:00:00.000Z	41	29 Jan
8	1985-12-25T00:00:00.000Z	39	25 Dec
22	1986-04-16T00:00:00.000Z	39	16 Apr
16	1987-03-08T00:00:00.000Z	38	08 Mar
2	1988-11-02T00:00:00.000Z	36	02 Nov
12	1989-02-27T00:00:00.000Z	36	27 Feb
4	1990-07-30T00:00:00.000Z	35	30 Jul
17	1990-09-21T00:00:00.000Z	35	21 Sep
9	1991-04-05T00:00:00.000Z	34	05 Apr
1	1992-05-14T00:00:00.000Z	33	14 May
21	1992-06-06T00:00:00.000Z	33	06 Jun
23	1991-11-23T00:00:00.000Z	33	23 Nov
6	1993-01-17T00:00:00.000Z	32	17 Jan
15	1993-05-19T00:00:00.000Z	32	19 May
11	1994-08-11T00:00:00.000Z	31	11 Aug
3	1995-03-22T00:00:00.000Z	30	22 Mar
14	1996-10-03T00:00:00.000Z	29	03 Oct
18	1995-12-12T00:00:00.000Z	29	12 Dec
7	1997-09-09T00:00:00.000Z	28	09 Sep
25	1997-02-14T00:00:00.000Z	28	14 Feb
29	1996-12-30T00:00:00.000Z	28	30 Dec
19	1998-07-07T00:00:00.000Z	27	07 Jul
26	1999-08-19T00:00:00.000Z	26	19 Aug
27	2000-03-04T00:00:00.000Z	25	04 Mar

customer_id

date_of_birth

age_years

birthday

1982-06-18T00:00:00.000Z

18 Jun

1984-01-29T00:00:00.000Z

29 Jan

1985-12-25T00:00:00.000Z

25 Dec

1986-04-16T00:00:00.000Z

16 Apr

1987-03-08T00:00:00.000Z

08 Mar

1988-11-02T00:00:00.000Z

02 Nov

1989-02-27T00:00:00.000Z

27 Feb

1990-07-30T00:00:00.000Z

30 Jul

1990-09-21T00:00:00.000Z

21 Sep

1991-04-05T00:00:00.000Z

05 Apr

1992-05-14T00:00:00.000Z

14 May

1992-06-06T00:00:00.000Z

06 Jun

1991-11-23T00:00:00.000Z

23 Nov

1993-01-17T00:00:00.000Z

17 Jan

1993-05-19T00:00:00.000Z

19 May

1994-08-11T00:00:00.000Z

11 Aug

1995-03-22T00:00:00.000Z

22 Mar

1996-10-03T00:00:00.000Z

03 Oct

1995-12-12T00:00:00.000Z

12 Dec

1997-09-09T00:00:00.000Z

09 Sep

1997-02-14T00:00:00.000Z

14 Feb

1996-12-30T00:00:00.000Z

30 Dec

1998-07-07T00:00:00.000Z

07 Jul

1999-08-19T00:00:00.000Z

19 Aug

2000-03-04T00:00:00.000Z

04 Mar