example_3.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<peter> "parent_of"@[] /u<peter> .
  /u<mary>  "parent_of"@[] /u<john> .
  /u<mary>  "parent_of"@[] /u<anne> .
  /u<mary>  "parent_of"@[] /u<amy>
};

# Does any of Joe's grandchildren have the same name of his parent?
SELECT ?offspring, ?grandchildren
FROM ?family
WHERE {
  /u<joe> AS ?grandparent ID ?grandparent_name "parent_of"@[] ?offspring .
  ?offspring                                     "parent_of"@[] ?grandchildren
}
HAVING ?offspring = ?grandchildren;

# Who are Joe's grandchildren that do not have the same name of his parent?
SELECT ?offspring, ?grandchildren
FROM ?family
WHERE {
  /u<joe> AS ?grandparent ID ?grandparent_name "parent_of"@[] ?offspring .
  ?offspring                                     "parent_of"@[] ?grandchildren
}
HAVING NOT(?offspring = ?grandchildren);

# Drop the graph.
DROP GRAPH ?family;