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.
g00se
0
Newbie Poster
Recommended Answers
Jump to PostAll the queries I fired gave inaccurate count values.
Show your queries.
All 4 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
g00se
0
Newbie Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
g00se
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.