demo, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

CREATE TABLE drink
    (`id` int, `name` varchar(12), `location` int, `alcohol` int)
;
    
INSERT INTO drink
    (`id`, `name`, `location`, `alcohol`)
VALUES
    (1, 'Ginger Ale', 13, 0),
    (2, 'Whiskey', 1, 1),
    (3, 'Vodka', 2, 1),
    (4, 'Rum', 3, 1),
    (5, 'Gin', 4, 1),
    (6, 'Tequila', 5, 1),
    (7, 'Triple Sec', 6, 1),
    (8, 'Cola', 14, 0),
    (10, 'Cherry Vodka', 7, 1),
    (11, 'Sprite', 15, 0),
    (12, 'Sour Mix', 0, 0),
    (13, 'Lemon Juice', 0, 0),
    (14, 'Lime Juice', 0, 0),
    (15, 'Grenadine', 0, 0),
    (16, 'Orange Juice', 16, 0)
;

CREATE TABLE cocktail
    (`id` int, `name` varchar(5), `comment` varchar(33))
;
    
INSERT INTO cocktail
    (`id`, `name`, `comment`)
VALUES
    (1, 'Item1', 'Whiskey Ginger'),
    (2, 'Item2', 'Screwdriver'),
    (3, 'Item3', 'Cherry Vodka and Sprite'),
    (4, 'Item4', 'Bartender''s Long Island Iced Tea'),
    (5, 'Item5', 'Long Island Iced Tea'),
    (6, 'Item6', 'Gin and Sin')
;

CREATE TABLE mix
    (`id` int, `drinkID` int, `cocktailID` int, `ounces` int)
;
    
INSERT INTO mix
    (`id`, `drinkID`, `cocktailID`, `ounces`)
VALUES
    (1, 1, 1, 4.00),
    (2, 2, 1, 1.00),
    (9, 10, 3, 1.00),
    (10, 11, 3, 4.00),
    (11, 5, 4, 0.75),
    (12, 4, 4, 0.75),
    (13, 6, 4, 0.75),
    (14, 3, 4, 0.75),
    (15, 7, 4, 1.00),
    (16, 12, 4, 1.00),
    (17, 8, 4, 1.00),
    (18, 3, 5, 0.75),
    (19, 5, 5, 0.75),
    (20, 4, 5, 0.75),
    (21, 6, 5, 0.75),
    (22, 12, 5, 2.00),
    (23, 8, 5, 1.00),
    (24, 7, 5, 1.00),
    (25, 5, 6, 2.00),
    (26, 13, 6, 2.00),
    (27, 15, 6, 2.00),
    (28, 16, 6, 2.00),
    (33, 3, 2, 1.50),
    (34, 16, 2, 4.00)
;

select 
  c.comment, 
  d.name, 
  m.ounces 
from drink d 
inner join mix m
  on m.drinkID = d.ID 
inner join cocktail c
  on m.cocktailID = c.id;

drop table drink;
drop table mix;
drop table cocktail;


absolute service time: 0,4 sec