select drink.id, drink.name from ( select * from beverage where type = ? ) drink