Queries

This Section includes several query examples that you can execute from the Studio's Browse Tab, or from its Graph Editor. You may also execute these queries directly from the Console, or your application through an API or Driver.

Note: the screen-shots included in this Section have been taken with version 0.76 of the demo database. While the queries remain valid, future versions of the demo database may include different records.

The following table can help you navigate through all examples:

Category Question Link
Profiles Find the 'year of birth' of the Profiles, and how many Profiles were born in the same year Link
Find the top 3 Profiles that have the highest number of Friends Link
Friendship Find Santo's Friends Link
Find Santo's Friends who are also Customers Link
Find Santo's Friends who are also Customers, and the Countries they are from Link
Find Santo's Friends who are also Customers, and the Orders they have placed Link
Among Santo's Friends, find the top 3 Customers that placed the highest number of Orders Link
Among Santo's Friends, find the top 3 Customers that visited the highest number of Places Link
Find all the Friends of Customer identified with OrderedId 1 that are not Customers (so that a product can be proposed) Link
Customers Find everything that is connected (1st degree) to Customer with OrderedId 1 Link
Find all Locations connected to Customer with OrderedId 1 Link
Find all Locations connected to Customer with OrderedId 1, and their Reviews (if any) Link
Find the other Customers that visited the Locations visited by Customer with OrderedId 1 Link
Find all the places where Customer with OrderedId 2 has stayed Link
Find all places where Customer with Id 1 has eaten Link
Find the 3 Customers who made more reviews Link
Find all Orders placed by Customer with OrderedId 2 Link
Calculate the total revenues from Orders associated with Customer with OrderedId 2 Link
Find the 3 Customers who placed most Orders Link
Find the top 3 Countries from where Customers are from Link
Countries Find the top 3 Countries from where Customers are from Link
Find Santo's Friends who are also Customers, and the Countries they are from Link
Orders Calculate the total revenues from Orders, and the min, max and average Order amount Link
Find the year of the Orders, and how many Orders have been placed in the same year Link
Find the 3 Customers who placed most Orders Link
Find the top 3 Customers in terms of spending Link
Find all Orders placed by Customer with Id 2 Link
Calculate the total revenues from Orders associated with Customer with Id 2 Link
Attractions Find all Attractions connected with Customer with OrderedId 1 Link
Services Find all Services connected with Customer with OrderedId 1 Link
Find the 3 Hotels that have been booked most times Link
Find the 3 Hotels that have most reviews Link
Find the top 3 nationality of the tourists that have eaten at Restaurant with Id 26 Link
Locations Find all Locations visited by Santo Link
Find all Locations connected to Customer with OrderedId 1 Link
Find all Locations connected to Customer with OrderedId 1, and their Reviews (if any) Link
Find all Locations visited by Customer with OrderedId 2 Link
Find all Locations visited by Santo's friends Link
Reviews Find number of Reviews per star Link
Find all reviewed Services Link
Find all reviewed Services and the Customer who made the review Link
Find the numbers of reviews per Service Link
Find the 3 Hotels that have most reviews Link
Find the 3 Customers who made more reviews Link
Recommendations Recommend some friends to Profile 'Isabella Gomez' (friends of friends) Link
Recommend some Hotels to Customer with OrderedId 1 Link
Business Opportunities Find all the Friends of Customer identified with OrderedId 1 that are not Customers (so that a product can be proposed) Link
Find all the Customer Friends that are not Customers (so that a product can be proposed) Link
Polymorphism Find all Locations (Services + Attractions) connected with Customer with OrderedId 1 Link
Find the 3 Services (Hotels + Restaurants) that have most reviews Link
Shortest Paths Find the shortest path between the Profile 'Santo' and the Country 'United States' Link
Find the shortest path between the Profile 'Santo' and the Restaurant 'Malga Granezza' Link
Traverses Traverse everything from Profile 'Santo' up to depth three Link
Traverse everything from Country 'Italy' up to depth three Link

results matching ""

    No results matching ""