Design with code in T-SQL language a block of instructions that calculates the average age of employees, and show us a message by console indicating whether the average exceeds 50 years of age or not.
employees table
Someone tells me how I get the age ...
For this you need to support yourself in a function called DATEDIFF , which receives 3 parameters, initial age, final age and the data you need (year, day, month, etc.).
SELECT *, -- Las columnas de tu tabla
DATEDIFF(YEAR, BirthDate, GETDATE()) -- El cálculo
FROM TABLA