Assume each table contains many more rows than are shown in the sample SQL QUEST

Question

Assume each table contains many more rows than are shown in the sample

SQL QUESTION

6. Write a SQL query to retrieve the first and last name of the employee with an employeeID of 7.

7. Using only the Employee table, write a SQL query to retrieve the names of all the cities with more than twelve

employee, along with the number of employees in each of these cities.

The following data samples show a few rows from each table. For the questions that follow, assume that each table contains many more rows than are shown here. employee ID employeeFirstName employee LastName employee HomeCity employeeHomeState Smith Boston MA 1 John 2 Jane Boston MA NY Johnson 3 Sue New York Johnson New York 4 Tim Employee employerCity employer State employerID employer Name CA 1 Stark Industries Los Angeles 2 Initech Newark NJ CA Los Angeles 3 Acme Corporation NY 4 Wayne Enterprises New York City Employer employee Employerl employeelD employerlD date Hired 11 4 2005-08-05 22 2007-04-02 33 1 2006-05-09 4 1 2005- 11-25 EmployeeEmployer

Explanation / Answer

6.select employeeFirstName,employeeLastName from Employee where employeeID=7;

7.select employeeHomeCity from Employee ;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.