Hello I am stuck on sql statements on how to piece them together. Here are the 2

Question

Hello I am stuck on sql statements on how to piece them together. Here are the 2 questions I need assistance on, as the SELECT, FROM, WHERE, GROUP BY and ORDER BY clauses is where I get hung up at: These are the questions it is asking: #1 - list all branches sorted and grouped by city. #2 - what is the average salary of all employees in the London branch

Explanation / Answer

1> SELECT column_name(s) FROM table_name WHERE column_name operator value AND ORDER BY city AND GROUP BY city 2> SELECT AVG(London) FROM table_name

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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