1.
Write an SQL query to retrieve the firstname, lastname, department name, and country of
the employees who were hired before the manager of the Sales department. Employees who work
in the Sales department should be excluded. INCLUDE THE OUTPUT IN YOUR SUBMISSION.
FIRST_NAME
LAST_NAME
DEPARTMENT_NAME
COUNTRY_NAME
Curtis
Davies
Shipping
United States of America
Lex
De Haan
Executive
United States of America
Bruce
Ernst
IT
United States of America
Pat
Fay
Marketing
Canada
William
Gietz
Accounting
United States of America
Michael
Hartstein
Marketing
Canada
Shelley
Higgins
Accounting
United States of America
Alexander
Hunold
IT
United States of America
Steven
King
Executive
United States of America
Neena
Kochhar
Executive
United States of America
Diana
Lorentz
IT
United States of America
Randall
Matos
Shipping
United States of America
Kevin
Mourgos
Shipping
United States of America
Trenna
Rajs
Shipping
United States of America
Peter
Vargas
Shipping
United States of America
Jennifer
Whalen
Administration
United States of America