SPARQL Queries equivalent to the competency questions of Exercice 2 =================================================================== 1. SELECT ?instrument WHERE { :flea :plays ?instrument . } 2. SELECT ?member WHERE { ?membership :hasBand :red_hot_chili_peppers . ?membership :hasTimePeriod :time_period_2 . ?membership :hasMember ?member . } 3. SELECT ?role WHERE { ?rolemembership :hasBand :red_hot_chili_peppers . ?rolemembership :hasTimePeriod :time_period_2 . ?rolemembership :hasMember :antony_kiedis . ?rolemembership :hasRole ?role . } 4. SELECT ?timeperiod WHERE { :stadium_arcadium :recordedDuring ?timeperiod . } 5. SELECT ?count WHERE { :stadium_arcadium :hasTracks ?count . } NOTE: the following query returns the correct answer only if all the tracks of an album are actually entered into the ontology SELECT COUNT(?track) COUNT ?count WHERE { :stadium_arcadium :hasTrack ?track . } 6. SELECT ?timeperiod WHERE { :stadium_arcadium :releasedOn ?timeperiod . } 7. SELECT ?song WHERE { :stadium_arcadium_hump_de_bump :isRecordingOf ?song . } 8. SELECT ?timeperiod WHERE { :hump_de_bump :composedOn ?timeperiod . } 9. SELECT ?text WHERE { ?criticmembership :criticMembershipHasPerson :crian_hiatt . ?criticmembership :criticMembershipHasAlbum :stadium_arcadium . ?criticmembership :criticMembershipHasCritic ?critic . ?critic rdfs:label ?text . } 10. SELECT ?timeperiod WHERE { :performance_1 :performanceHasTimePeriod ?timeperiod . } 11. SELECT ?song WHERE { :performance_1 :performanceHasSong ?song . } 12. SELECT ?place WHERE { :performance_1 :performanceHasPlace ?place . } 13. SELECT ?regionname WHERE { :portland :isCityOf ?region . ?region rdfs:label ?regionname . } 14. SELECT ?countryname WHERE { :oregon :isRegionOf ?country . ?country rdfs:label ?countryname . }