Database schema:

CREATE TABLE beers (
	id INTEGER NOT NULL -- example: ['2688', '2687'],
	brewery_id INTEGER NOT NULL -- example: ['0', '1'],
	abv REAL -- example: ['0.087', '0.065'],
	ibu REAL -- example: ['85.0', '65.0'],
	name TEXT NOT NULL -- example: ['Gordon Ale (2009)', "Dale's Pale Ale"],
	style TEXT -- example: ['American Pale Ale (APA)', 'American Double / Imperial IPA'],
	ounces REAL NOT NULL -- example: ['12.0', '16.0'],
	PRIMARY KEY (id), 
	CONSTRAINT fk_beers_breweries FOREIGN KEY(brewery_id) REFERENCES breweries (id)
)


CREATE TABLE breweries (
	id INTEGER NOT NULL -- example: ['0', '1'],
	name TEXT -- example: ['Against the Grain Brewery', 'NorthGate Brewing '],
	city TEXT -- example: ['Louisville', 'Minneapolis'],
	state TEXT -- example: ['KY', 'MN'],
	PRIMARY KEY (id)
)

Question: Which city and state produces the most and least bitter beer, and what is the difference in bitterness between the two? List also the names of the beer.
Evidence: The more IBU, the more bitter the beer is, most bitter means highest IBU; The less IBU, the less bitter the beer is, least bitter means lowest IBU

SQL:
SELECT T1.state, T1.city, T2.name, T2.ibu FROM breweries AS T1 INNER JOIN beers AS T2 ON T1.id = T2.brewery_id GROUP BY T1.state, T1.city, T2.name, T2.ibu HAVING MAX(ibu) AND MIN(ibu) LIMIT 2