Write a SQL query to return the last name of all of employees who serve customers from more than 5 different cities alon
Posted: Sat May 14, 2022 8:17 pm
Write a SQL query to return the last name of all of employees
who serve customers from more than 5 different cities along with
the name of the manager that they report to. Sort by the
last name of the employee.
Cities are represented in names.
SupportRepId is the same as the EmployeeId
employees (o Constraints Structure Data Grid view ES X K E Filter data Emp LastName FirstName Title Reports To BirthDate 1 1 Adams Andrew NULL 1962-02-18 2 2 Edwards Nancy 1 1958-12-08 3 3 Peacock Jane General Manager Sales Manager Sales Support Agent Sales Support Agent Sales Support Agent 2 1973-08-25 4 4 Park Margaret 2 1947-09-19 5 5 Johnson Steve 2 1965-03-03 6 6 Mitchell Michael IT Manager 1 1973-07-01 7 7 King Robert IT Staff 6 1970-05-29 8 8 Callahan Laura IT Staff 6 1968-01-09
customers (C Structure Data Constraint t 994 Online_MI Table name: customers WITHOUT ROWID Name Data type Primary Foreign Key Key Unique Check Not NULL Collate Ge 1 Customerld INTEGER 2 FirstName NVARCHAR (40) 3 Last Name NVARCHAR (20) 4 Company NVARCHAR (80) 5 Address NVARCHAR (70) 6 City NVARCHAR (40) 7 State NVARCHAR (40) 8 Country NVARCHAR (40) 9 PostalCode NVARCHAR (10) 10 Phone NVARCHAR (24) 11 Fax NVARCHAR (24) 12 Email NVARCHAR (60) 13 SupportRepld INTEGER
who serve customers from more than 5 different cities along with
the name of the manager that they report to. Sort by the
last name of the employee.
Cities are represented in names.
SupportRepId is the same as the EmployeeId
employees (o Constraints Structure Data Grid view ES X K E Filter data Emp LastName FirstName Title Reports To BirthDate 1 1 Adams Andrew NULL 1962-02-18 2 2 Edwards Nancy 1 1958-12-08 3 3 Peacock Jane General Manager Sales Manager Sales Support Agent Sales Support Agent Sales Support Agent 2 1973-08-25 4 4 Park Margaret 2 1947-09-19 5 5 Johnson Steve 2 1965-03-03 6 6 Mitchell Michael IT Manager 1 1973-07-01 7 7 King Robert IT Staff 6 1970-05-29 8 8 Callahan Laura IT Staff 6 1968-01-09
customers (C Structure Data Constraint t 994 Online_MI Table name: customers WITHOUT ROWID Name Data type Primary Foreign Key Key Unique Check Not NULL Collate Ge 1 Customerld INTEGER 2 FirstName NVARCHAR (40) 3 Last Name NVARCHAR (20) 4 Company NVARCHAR (80) 5 Address NVARCHAR (70) 6 City NVARCHAR (40) 7 State NVARCHAR (40) 8 Country NVARCHAR (40) 9 PostalCode NVARCHAR (10) 10 Phone NVARCHAR (24) 11 Fax NVARCHAR (24) 12 Email NVARCHAR (60) 13 SupportRepld INTEGER