Where in New York can you locate the brewery that makes the bitterest beer? List both the brewery's name and the name of the city.
The more IBU, the more bitter the beer is, bitterest means highest IBU.
SELECT T2.name, T2.city FROM beers AS T1 INNER JOIN breweries AS T2 ON T1.brewery_id = T2.id WHERE T2.state = 'NY' ORDER BY T1.ibu DESC LIMIT 1
CREATE TABLE breweries
(
    id    INTEGER          not null
        primary key,
    name  TEXT null,
    city  TEXT null,
    state TEXT null
);
CREATE TABLE IF NOT EXISTS "beers"
(
    id         INTEGER not null
        primary key,
    brewery_id INTEGER not null
        constraint beers_ibfk_1
            references breweries,
    abv        REAL,
    ibu        REAL,
    name       TEXT    not null,
    style      TEXT,
    ounces     REAL    not null
);
CREATE INDEX brewery_id
    on beers (brewery_id);
