How to write a query to get wine pairing for a pizza based on pairing weight

I am working on a query to pair drinks to pizzas. Currently I am able to show the pizza_name, beverage and the pairing_weight being the amount of toppings on a pizza that the beverage pairs with. From here, I am looking to just output a mapping of distinct pizza name to beverage. I am unsure how to format the query to just return the top result per pizza based on pairing_weight.

mysql> select pizza_name, beverage, COUNT(beverage) as pairing_weight     -> from pizza_production     ->     JOIN pizza_restrictions pr on     ->         pizza_production.topping_name = pr.topping_name     ->     JOIN beverage_pairing_notes on     ->         restriction = pairing     ->     GROUP BY pizza_name, beverage     ->     ORDER BY pizza_name, pairing_weight DESC; +--------------+--------------------+----------------+ | pizza_name   | beverage           | pairing_weight | +--------------+--------------------+----------------+ | Grand Padano | Prosecco           |              2 | | Grand Padano | Champagne          |              2 | | Grand Padano | Riesling           |              2 | | Grand Padano | Cava               |              2 | | Grand Padano | Pinot Noir         |              1 | | Grand Padano | Carlsberg beer     |              1 | | Grand Padano | Zinfandel Rosé     |              1 | | Grand Padano | Chardonnay         |              1 | | Grand Padano | Chenin Blanc       |              1 | | Grand Padano | Gewürztraminer     |              1 | | Grand Padano | Guinness beer      |              1 | | Grand Padano | Pinot Grigio       |              1 | | Grand Padano | Heineken beer      |              1 | | Grand Padano | Irn Bru            |              1 | | Grand Padano | Malbec             |              1 | | Grand Padano | Muscat Blanc       |              1 | | new york     | Riesling           |              2 | | new york     | Champagne          |              2 | | new york     | Prosecco           |              2 | | new york     | Pinot Noir         |              2 | | new york     | Malbec             |              2 | | new york     | Syrah              |              1 | | new york     | Cava               |              1 | | new york     | Cabernet Sauvignon |              1 | | new york     | Chardonnay         |              1 | | new york     | Carlsberg beer     |              1 | | new york     | Chenin Blanc       |              1 | | new york     | Gewürztraminer     |              1 | | new york     | Guinness beer      |              1 | | new york     | Muscat Blanc       |              1 | | new york     | Heineken beer      |              1 | | pepperoni    | Pinot Noir         |              3 | | pepperoni    | Malbec             |              3 | | pepperoni    | Muscat Blanc       |              2 | | pepperoni    | Heineken beer      |              2 | | pepperoni    | Guinness beer      |              2 | | pepperoni    | Gewürztraminer     |              2 | | pepperoni    | Chenin Blanc       |              2 | | pepperoni    | Riesling           |              2 | | pepperoni    | Carlsberg beer     |              2 | | pepperoni    | Cabernet Sauvignon |              2 | | pepperoni    | Chardonnay         |              1 | | pepperoni    | Champagne          |              1 | | pepperoni    | Prosecco           |              1 | | pepperoni    | Cava               |              1 | | pepperoni    | Rioja              |              1 | | pepperoni    | Syrah              |              1 | | pepperoni    | Zinfandel Rosé     |              1 | | vegetarian   | Diet Coke          |              2 | | vegetarian   | Prosecco           |              1 | | vegetarian   | Champagne          |              1 | | vegetarian   | Riesling           |              1 | +--------------+--------------------+----------------+ 52 rows in set (0.01 sec) 

An example of desired output would be

+--------------+--------------------+ | pizza_name   | beverage           | +--------------+--------------------+ | pepperoni    | Pinot Noir         | | new york     | Riesling           | | Grand Padano | Prosecco           | | vegetarian   | Diet Coke          | +--------------+--------------------+ 

Is there a way to pull this data from what I already have in the output of the query above? Thank you.