-- cocantenate FirstName || LastName AS Name
Select
FirstName || ' ' || LastName AS Name,
Title
FROM employees
WHERE Title IN ('General Manager', 'Sales Manager', 'IT Manager');
-- WHERE ('General Manager', 'Sales Manager', 'IT Manager') IN Title;
-- WHERE Title = 'General Manager' OR Title = 'IT Manager' OR Title = 'Sales Manager';