/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This example illustrates use of keyword ANY in where clause.
  This query returns events that will occur on venues with capacity more than in venue 3 or 4.*/

select e1."Event_Name", v2."Capacity"
  from "events" e1, "venues" v2
 where (e1."VenueNo" = v2."VenueNo") and
       (v2."Capacity" > any (select v."Capacity" from "venues" v where v."VenueNo" between 3 and 4))
