[solved]-Write Following Query Sql Using Group Clause May Use Following Operators Exists Exists Div Q39022871

Write the following query in SQL using a GROUP BY but no HAVINGclause. (You may not use any of the following operators: IN, NOTIN, EXISTS, NOT EXISTS, ALL, ANY, )

For each division (of any company) that employs at least 200people, find the average salary of all the people the divisionemploys.

company(co_name, govt_id, ceo_ssn, hq_loc) division(co id, div name, subdiv of, dir ssn, div_hq) site(co id, diy 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, diy 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 using a GROUP BY but no HAVING clause. (You may not use any of the following operators:… . . .