Please help me in the following question: Given the following three tables Table 1: specialization (name,department) Table 2: area (a_name,phone,address) Table 3: dep_loc (area_name,department) where the "area_name" attibute in dep_loc references "a_name" in area. Write a query to give a count of the number of people that work in each area So the result should look something like this **area name** | **count** new york | 1 washington| 1 also, if were to insert a new row into table area , what modification should i make to the above query so that the new row is accounted for? All the queries I fired gave inaccurate count values. Not sure where I'm going wrong.
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.