Countries and Their Preferences for Beer, Spirit, and Wine
Create a SQL query to find all countries and their preference for beer, spirit, and wine, based on the highest serving type as their preference. The output should show only the countries whose preferences are wine and spirits, ordered in ascending order of the country name.
These are the tables to query for this question:
playground.drinks- country string
- beer_servings int
- spirit_servings int
- wine_servings int
- total_litres_of_pure_alcohol double
Your answer should include these columns:
- country varchar
- preferred_drink varchar
Querying is only for logged in users!
Sign In