Page 1 of 1

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
by answerhappygod
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.
Write A Sql Query To Return The Last Name Of All Of Employees Who Serve Customers From More Than 5 Different Cities Alon 1
Write A Sql Query To Return The Last Name Of All Of Employees Who Serve Customers From More Than 5 Different Cities Alon 1 (97.99 KiB) Viewed 50 times
Write A Sql Query To Return The Last Name Of All Of Employees Who Serve Customers From More Than 5 Different Cities Alon 2
Write A Sql Query To Return The Last Name Of All Of Employees Who Serve Customers From More Than 5 Different Cities Alon 2 (354.11 KiB) Viewed 50 times
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