Question: Need help with the following SQL Statement. Which Employees live in the same state as each other? What are their names and where do they

Need help with the following SQL Statement.

Which Employees live in the same state as each other? What are their names and where do they live.

Who is the youngest?

Salesperson Table is as follows

EmployeeID EmployeeName EmployeeAddress EmployeeCity EmployeeState EmployeeZip EmployeeBirthDate EmployeeDateHired EmployeeSupervisor Height Weight
123-44-345 Phil Morris 2134 Hilltop Rd Knoxville TN NULL 1949-05-01 1975-12-06 454-56-768 72 172
332445667 Lawrence Haley 5970 Spring Crest Rd Nashville TN 54545 1963-08-15 1999-05-01 454-56-768 66 165
454-56-768 Robert Lewis 17834 Deerfield Ln Knoxville TN 55555 1964-08-25 1998-01-01 123-44-345 74 160
555955585 Mary Smith 75 01e Lane Clearwater FL 33879 1969-06-05 2000-08-15 332445667 71 155
Laura Laura Ellenburg 5342 Picklied Trout Lane Nashville TN 38010 NULL 2000-02-22 454-56-768 76 268

Thanks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Hello, I am working on SQL codes but I just can't figure out these remaining questions. Would anyone be able to help? 5.4) Write an SQL statement to list the Name of employees who have worked on a...

Q:

QUESTION 1) Run the following SQL statement to create a new table for inserting and storing the employees' salaries. Run the following statement to create CREATE TABLE TOP_SALARIES (salary NUMBER...

Q:

This task uses a relational database schema and instance adapted from Fundamentals of Database Systems, Elmasri and Navathe. (Question 5.11), given below. Most of the attribute names are...

Q:

Course Haan Counam Frekulli Student Sme Shame 10 ans Ger AM Annan Agabe trbid CONGO 100 200 300 900 100 300 500 30 Yagot 40 30 60 Ali Data Structure Dame Seems analysis F F M M 3 3 2 Fadly Regtb] Sto...

Q:

Part 2: DDL Instructions: Using the guidance and instructions given in the module download and install the appropriate version of PostgreSQL for your system. Familiarize yourself with the pgAdmin web...

Q:

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

Q:

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

Q:

2. Write an SQL Query that will produce a list of Employees first name, and their Department Names. Show the SQL below: 3. Write an SQL Query that will produce a list of Employees first name, and...

Q:

1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is identified by a...

Q:

How could a well-managed database help the company better achieve its goals? v Hint: refer to Text Chapter 1 for " Advantages of database approach " and apply that understanding to the GG project...

Q:

Wainwright Corporation had the following activities in 2010. 1. Sale of land.............................................................$180,000 2. Purchase of...

Q:

Rouse Company, a real estate developer, is well known as one of the few U.S. companies to have reported the current value of property and equipment in its financial statements. As mentioned in the...

Q:

What are the advantages of the Tax Registration Number ( TRN ) ? Are there any dis - advantages. Discuss ( 5 marks ) Define and explain the following P 2 4 . ( 3 marks ) P 4 5 . ( 3 marks ) What is...

Q:

Use the following information to answer the question(s) below. Firm Portfolio Weight Volatility Correlation w/ Market Portfolio Taggart Transcontinental 0.25 14% 0.7 Wyatt Oil 0.35 18% 0.6 Rearden...

Q:

Explain the difference between Job Analysis, Job Classification, and Job Evaluation.

Q:

What does Processing of an OLAP Cube accomplish?

Q:

After designing a Multidimensional Database in Visual Studio, what are the next steps that build the Database in the Analysis Services Instance? How is the build out of the Analytical Services...