example_2.bql

# Copyright 2016 Google Inc. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

# Create a graph.
CREATE GRAPH ?family, ?cars;

# Insert some data into the family graph.
INSERT DATA INTO ?family {
  /u<joe>   "parent_of"@[] /u<mary> .
  /u<joe>   "parent_of"@[] /u<peter> .
  /u<peter> "parent_of"@[] /u<eve> .
  /u<mary>  "parent_of"@[] /u<john> .
  /u<mary>  "parent_of"@[] /u<anne> .
  /u<mary>  "parent_of"@[] /u<amy>
};

# Insert some data into the car graph.
INSERT DATA INTO ?cars {
  /u<joe>   "drives"@[] /c<lexus> .
  /u<mary>  "drives"@[] /c<mazda> .
  /u<peter> "drives"@[] /c<honda> .
  /u<eve>   "drives"@[] /c<acura> .
  /u<john>  "drives"@[] /c<subaru> .
  /u<anne>  "drives"@[] /c<mini> .
  /u<amy>   "drives"@[] /c<subaru> .
  /u<mike>  "drives"@[] /c<volvo> .
  /u<kim>   "drives"@[] /c<toyota> .
  /u<elon>  "drives"@[] /c<tesla>
};

# How many grandchildren does Joe have?
SELECT ?grandparent_name, COUNT(?grandchildren) AS ?number_of_grandchildren
FROM ?family
WHERE {
  /u<joe> AS ?grandparent ID ?grandparent_name "parent_of"@[] ?offspring .
  ?offspring                                     "parent_of"@[] ?grandchildren
}
GROUP BY ?grandparent_name;

# How many different brands of car manufactures do we know?
SELECT ?manufacturer
FROM ?cars
WHERE {
  ?owner "drives"@[] ?car ID ?manufacturer
}
GROUP BY ?manufacturer;

# What cars does Joe's grandchildren's drive in descending order?
SELECT ?manufacturer
FROM ?family, ?cars
WHERE {
  /u<joe>         "parent_of"@[] ?offspring .
  ?offspring      "parent_of"@[] ?grandchildren .
  ?grandchildren "drives"@[] ?car ID ?manufacturer
}
GROUP BY ?manufacturer
ORDER BY ?manufacturer DESC;

# For any unique owner and manufacture, list the manufacture in descending
# order, and for each manufacture order the owners in ascending order.
SELECT ?manufacturer, ?owner
FROM ?family, ?cars
WHERE {
  ?owner_node ID ?owner "drives"@[] ?car ID ?manufacturer
}
GROUP BY ?owner, ?manufacturer
ORDER BY ?manufacturer DESC, ?owner ASC;

# List the manufactures in descending order by number of owners.
SELECT ?manufacturer, COUNT(?owner) AS ?owners
FROM ?family, ?cars
WHERE {
  ?owner_node ID ?owner "drives"@[] ?car ID ?manufacturer
}
GROUP BY ?manufacturer
ORDER BY ?owners DESC;

# Drop the graph.
DROP GRAPH ?family, ?cars;