| 123456789101112131415 |
- MATCH (staff:/mingdao1/staff WHERE attr1 = '钟宏')-[:is_solve_person_of_case]->(case:/mingdao1/case WHERE attr30 >= '2024-01-01' AND attr30 <= '2024-12-31')-[:is_case_of_project]->(project:/mingdao1/project)<-[:is_contract_of_project]-(contract:/mingdao1/contract), (project)<-[:is_admin_of_project]-(pm:/mingdao1/staff)
- RETURN contract.attr18 AS "contract_amount", pm.attr1 AS "pm_name", pm.attr0 AS "pm_id"
- WHERE contract_amount is not null
- ORDER BY contract_amount desc
- LIMIT 5
- /**
- output()
- **/
- ;
|