<reponame>geophile/sql-layer<filename>fdb-sql-layer-core/src/test/resources/com/foundationdb/sql/optimizer/operator/coia-group-index/select-5.sql<gh_stars>0
SELECT customers.name
  FROM customers LEFT JOIN addresses ON customers.cid = addresses.cid
 WHERE addresses.state IS NULL
   AND customers.name > 'M'