Consider two fields—B_date, which stores the birth date, and J_date, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on joining date.
SELECT (YEAR(J_DATE) - YEAR(B_DATE));