Write a SQL query to return the last name of all of employees who serve customers from more than 5 different cities alon

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Write a SQL query to return the last name of all of employees who serve customers from more than 5 different cities alon

Post 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 46 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 46 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply