Given any one of the database models in question $16($above$),$ you want to return a list of all employees by name and their seniority level. Employees who have worked for the company over $10$ years are $$very senior$$; employees who have worked for the company between $5$ and $10$ years are $$experienced$$; employees who have worked less than $5$ years are $$junior$$ What would you need to do to produce a report like this?

first$\_$name last$\_$name seniority$\_$level

Alex Rodriguez very senior

Carmen Williams junior

Phyllis Taylor experienced

A query using the UNION statement

An SQL function such as IF

A table alias

The query cannot be written given the database structure