For the next query, you want to create a new view that contains the employees name and whether or not they are a Sales Rep.

SELECT jobtitle

WHEN jobTitle $\text{'}\%$ Rep' THEN 'Yes'

$\text{'}$No$\text{'}$

$$

SalesRep

FROM employees;