[solved]-Write Following Query Sql Without Embedded Sub Queries Find Every Person Works Company Lea Q39022810

Write the following query in SQL without any embeddedsub-queries: Find every person who works for a company that has atleast two divisions each of which has at least two sites.

company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div_name, subdiv_of, dir_ssn, div_hq) site(co id, div_name, loc) product(prod id, manuf co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod id, manuf co Show transcribed image text company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div_name, subdiv_of, dir_ssn, div_hq) site(co id, div_name, loc) product(prod id, manuf co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod id, manuf co

Expert Answer

---

Answer to Write the following query in SQL without any embedded sub-queries: Find every person who works for a company that has at… . . .