SQL Example $2\mathrm{.}4$

An employee can be categorized by the date he or she was hired $($I know using how long the employee has

been in company makes more sense, but it will be difficult for readers to compare the solution because it

depends on when the reader runs the example.$).$ If an employee is hired before January $1,2013,$ he or she is

categorized as "Experienced". If an employee is hired on or after January $1,2013$ but before January $1,$

$2015,$ he or she is categorized as "Trained". If an employee is hired on or after January $1,2015,$ he or she is

categorized as "Novice". Display employee full name and the category.