Age From Date of Birth

Return each person's name and their age in whole years as of 2026-10-06, ordered by name.

Table schema

People(id INT PRIMARY KEY, name VARCHAR(50), dob DATE)

Sample data

id | name | dob
1 | Amy | 2000-10-06
2 | Ben | 2000-10-07
3 | Cara | 1990-01-15