The company requires 10 years of employment for an employee to be vested in the company's pension plan.

The company requires 10 years of employment for an employee to be vested in the company's pension plan. Give an example of how it looks for a SQL script that will display a list of employee's names, hire dates, years of service, and whether or not they are vested in the pension plan. use adventure works database if possible.