Queries with age and dates
I have problems handling age, could someone who knows help me with this please:
Objective: Carry out the query assembly or indicate how the database crossing should be carried out to obtain the age of clients and group by the following age ranges: 18 to 25, 26 to 35, 36 to 45, 46 to 55, 56 to 65, +65 years
The databases contain the following columns:
Product Base: Product ID, Product Description, Category ID, Department ID, Product Status, List Price.
Category Base: Category ID, Category Description, Registration Date.
Customer Base: Customer ID, Registration Date, Name, Last Name, Customer Status, Date of Birth, Gender.
Sales Base: Ticket ID, Sale Date, Customer ID, Product ID, Sale Price, Sales Channel, Payment Method, Branch, Type of Receipt.