QUESTION 11 5 points Saved Given the schema of Figure 3.20 on Page 108 of textbo

Question

QUESTION 11 5 points Saved Given the schema of Figure 3.20 on Page 108 of textbook. Which of the following SQL statement is a valid query? A, select w.company.name, count(employee name) from works as w, company as c where w.company_namec.company_name and salary> 200000 and count(employee_name)100 group by w.company_name; ·B, select count(employee- name)>= 100 from works as w, company as c where w.company.name = c.company.name and salary > 200000 group by w.company_name G, '. select w-company name, count(employee name) from works as w, company as c where w.company..name = c.company.name group by w.company_name having salary > 200000 and count(employee name) >= 100; D. select w.company_name, count(employee_name) from works as w, company as c where w.company_name c.company_name and salary>200000 group by w.company_name having count(employee name) >= 100;

Explanation / Answer

Answer :----

a). select w.company_name, count(employee_name)

from work as w, company as c

where w.company_name = c.company_name

and salary > 200000

group by w.company_name ;

It is the valid query.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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