Description
|
WITH nested_breweries AS
(SELECT bw.name AS brewer, bw.phone,
(SELECT br.name, br.abv FROM beers br
WHERE br.brewery_id = meta(bw).id) AS beers
FROM breweries bw)
SELECT VALUE nb FROM nested_breweries nb
WHERE (SOME b IN nb.beers SATISFIES b.name LIKE '%IPA%')
LIMIT 5;
and{no format}
WITH nested_breweries AS
(SELECT bw.name AS brewer, bw.phone,
(SELECT br.name, br.abv FROM beers br
WHERE br.brewery_id = meta(bw).id) AS beers
FROM breweries bw)
SELECT VALUE nb FROM nested_breweries nb
WHERE (EVERY b IN nb.beers SATISFIES b.name LIKE '%IPA%')
LIMIT 5;
work now.