col : unnamed: 0 | wine | rank | beer | rank.1 | spirits | rank.2 | total | rank| row 1 : yukon | 18.3 | 1 | 90.6 | 1 | 13.8 | 1 | 12.7 | 1 row 2 : northwest territories | 8.1 | 2 | 55.2 | 2 | 10.8 | 2 | 9.2 | 2 row 3 : alberta | 13.9 | 9 | 89.8 | 9 | 7.6 | 9 | 8.6 | 3 row 4 : newfoundland & labrador | 6.5 | 10 | 93.3 | 10 | 7.3 | 10 | 8.0 | 4 row 5 : british columbia | 14.5 | 7 | 76.6 | 7 | 9.0 | 7 | 7.8 | 5 row 6 : ontario | 11.8 | 8 | 84.3 | 8 | 8.8 | 8 | 7.8 | 6 row 7 : quebec | 17.4 | 12 | 93.9 | 12 | 4.1 | 12 | 7.8 | 7 row 8 : prince edward island | 7.4 | 3 | 78.9 | 3 | 9.7 | 3 | 7.5 | 8 row 9 : nova scotia | 8.0 | 5 | 79.5 | 5 | 9.1 | 5 | 7.5 | 9 row 10 : manitoba | 8.0 | 4 | 76.8 | 4 | 9.4 | 4 | 7.4 | 10 row 11 : saskatchewan | 5.0 | 6 | 76.8 | 6 | 9.1 | 6 | 7.0 | 11 row 12 : new brunswick | 8.4 | 11 | 79.8 | 11 | 6.8 | 11 | 6.7 | 12 row 13 : nunavut | data unavailable | data unavailable | data unavailable | data unavailable | data unavailable | data unavailable | data unavailable | data unavailable row 14 : canada | 13.1 | nan | 85.6 | nan | 7.5 | nan | 7.8 | nan
which locations consume the same total amount of alcoholic beverages as another location? which of these consumes more then 80 of beer? of those what was the consumption of spirits of the one that consumed the most beer?
4.1
Unnamed: 0 Wine Rank Beer Rank.1 Spirits Rank.2 Total Rank|
of those what was the consumption of spirits of the one that consumed the most beer?
Yukon 18.3 1 90.6 1 13.8 1 12.7 1
Northwest Territories 8.1 2 55.2 2 10.8 2 9.2 2
Alberta 13.9 9 89.8 9 7.6 9 8.6 3
Newfoundland & Labrador 6.5 10 93.3 10 7.3 10 8.0 4
British Columbia 14.5 7 76.6 7 9.0 7 7.8 5
Ontario 11.8 8 84.3 8 8.8 8 7.8 6
Quebec 17.4 12 93.9 12 4.1 12 7.8 7
Prince Edward Island 7.4 3 78.9 3 9.7 3 7.5 8
Nova Scotia 8.0 5 79.5 5 9.1 5 7.5 9
Manitoba 8.0 4 76.8 4 9.4 4 7.4 10
Saskatchewan 5.0 6 76.8 6 9.1 6 7.0 11
New Brunswick 8.4 11 79.8 11 6.8 11 6.7 12
Nunavut Data unavailable Data unavailable Data unavailable Data unavailable Data unavailable Data unavailable Data unavailable Data unavailable
Canada 13.1 nan 85.6 nan 7.5 nan 7.8 nan
4.1
of those what was the consumption of spirits of the one that consumed the most beer? || which of these consumes more then 80 of beer? | which locations consume the same total amount of alcoholic beverages as another location?