Is the hosted northwind sample database broken?

[way0utwest_He_Him_Hi (Way0utwest 🎙️ (He/Him/His))]

I was reading the basics of the Northwinds recommendation engine to experiment with queries (https://neo4j.com/graphgists/northwind-recommendation-engine/). I tried this query in the online hosted Northwind:

match (c:Customer)-[:PURCHASED]->(o:Order)-[:PRODUCT]->(p:Product)
return c.companyName, p.productName, count(o) as orders
order by orders desc
limit 5

When this runs, I get no records, and I see a squigggly under the [:product] section. The tip that pops up says this relationship doesn't exist. Is this on in the online demo.neo4jlabs.com sample site? Or is there something I need to do to create it?

[glilienfield (Gary Lilienfield)]

the screenshot shows the node labels and relationship types in the Northwind database. I don't see a PRODUCT relationship type.

It looks like the relationship type between an Order and a Product is ORDERS.

Try this:

match (c:Customer)-[:PURCHASED]->(o:Order)-[:ORDERS]->(p:Product)
return c.companyName, p.productName, count(o) as orders
order by orders desc
limit 5

[way0utwest_He_Him_Hi (Way0utwest 🎙️ (He/Him/His))]

@glilienfield

match (c:Customer)-[:PURCHASED]->(o:Order)-[:ORDERS]->(p:Product)
return c.companyName, p.productName, count(o) as orders
order by orders desc
limit 5

Thanks, that works. I didn't even think about Orders. I'm guessing that someone changed the edges here and lots of sample queries on the site and Internet are now wrong? Could someone add Purchased back?