Q 17: Complete to count projects per department:
MATCH (p:Project)-[:FUNDED_BY]-(d:Department)WITH d, COUNT(p) AS totalRETURN d.name, ___[Fill in the blank]
____;

Question

Q 17: Complete to count projects per department:
MATCH (p:Project)-[:FUNDED_BY]->(d:Department)WITH d, COUNT(p) AS totalRETURN d.name, ___[Fill in the blank]
____;

BlackTom AI · Accepted Answer

Aggregating with COUNT and aliasing: use COUNT(p) AS total and then return total.

1) Relevant knowledge points and concepts
- Cypher pattern matching: MATCH (p:Project)-[:FUNDED_BY]->(d:Department) finds each Project node p connected to a Department node d.
- Aggregation and grouping: COUNT(p) computes the number of matched p nodes per grouping key.
- WITH clause scope and aliasing: WITH d, COUNT(p) AS total groups results by d and creates the alias total for the aggregated count; subsequent clauses refer to total, not to p.
- RETURN uses variables available in scope (d and total after the WITH).

2) Step-by-step reasoning
- MATCH finds all (p,d) pairs where p is a Project funded by a Department d.
- Applying WITH d, COUNT(p) AS total groups the matched pairs by each department node d and computes the count of projects for that department, presenting that count under the name total.
- The RETURN clause should output the department name and that aliased count variable.

3) Intermediate steps / example values
- Suppose Department "HR" has 2 projects, "IT" has 5 projects.
- After WITH d, COUNT(p) AS total we have rows: {d.name: "HR", total: 2}, {d.name: "IT", total: 5}.
- RETURN d.name, total will then output:
  HR, 2
  IT, 5

4) Why the correct answer is correct
- The alias total produced by COUNT(p) in the WITH clause is the variable holding the per-department project count. RETURN must reference that alias to include the computed count in the output, so the blank should be total.

5) Why other options would be incorrect
- RETURN COUNT(p) would fail here because p is not carried forward after the WITH; only d and total are in scope. Returning a different name that wasn't defined (e.g., count or projects without alias) would produce an error or no value. Returning total is the correct reference to the aggregated value.

6) Conclusion
- The blank should be filled with total. This matches the provided answer: "total".

Q 17: Complete to count projects per department: MATCH (p:Project)-[:FUNDED_BY]->(d:Department)WITH d, COUNT(p) AS totalRETURN d.name, _[Fill in the blank] __; 多项填空题

类似问题

Q 27: Which query correctly finds people who are managed by Bob?

Q24: Which query finds people who have worked in R&D since before 2016?

Q 20: Which query correctly returns collaborators of David regardless of stored direction?

Q18: Which query returns person who are BOTH Engineer and Researcher and earn more than 125000?

Q16: Complete to return people who authored works with more than 20 citations: MATCH (p:Person)-[:[Fill in the blank] ]->(w:Work)WHERE w.[Fill in the blank] > 20RETURN p.name;

Q15: What does this return? MATCH (m:Manager)-[:MANAGES]->(e:Engineer) RETURN COUNT(e);

Q 14: Which query correctly finds Departments that are also FundingBody nodes?

Q 13: What does this return? MATCH (p:Person)-[:COLLABORATES_WITH]-(other) RETURN p.name, other.name;

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单

Q 17: Complete to count projects per department: MATCH (p:Project)-[:FUNDED_BY]->(d:Department)WITH d, COUNT(p) AS totalRETURN d.name, ___[Fill in the blank] ____; 多项填空题