asterix-app/src/test/resources/AQLTS/queries-sql-like/5.aql

from $event in dataset('Event')
where $event.name = "The Night of the Ad Eaters, 29th edition"
with $collocated_events :=
   from $collocated_event in dataset('Events')
   where $collocated_event.location.street ~= $event.location.street
   and $collocated_event.location.city = $event.location.city
   and $collocated_event.location.state = $event.location.state
   and $collocated_event.location.zip = $event.location.zip
   select { "event_name" : $collocated_event.name }
select { "collocated_evnets" : $collocated_events }