create a word document with all the screen shots (please number them) and submit just one file.
 
Write sql statements to do the following:
create the table "easy_drinks" in the "Drinks" database.
Insert the values using sql statements
Display all content for main, second, and directions
Display drink_name, and amount2 for only juices (in the second) in ascending order
Display drink_names and directions where amount1 is more than 1 oz
Display drinks that use "soda" as their base
Display all the drink names in descending order
Display drink_name, second, amount2, directions for "soda" based drinks
Display the structure/schema of the table (what are the data types for the columns)
Display the drink name and directions for "tea based drinks"
 
 

Transcribed Image Text:

drink_name Blackthorn Blue Moon Oh My Gosh Lime Fizz Kiss on the Lips Hot Gold Lone Tree Greyhound Indian Summer Bull Frog Soda and It main tonic water soda peach nectar Sprite cherry juice peach nectar soda soda apple juice iced tea soda amount] 1.5 1.5 1 1.5 2 3 1.5 1.5 2 1.5 2 easy_drinks second pineapple juice blueberry juice pineapple juice lime juice apricot nectar orange juice cherry juice grapefruit juice hot tea lemonade grape juice amount2 1 .75 1 75 7 6 .75 5 6 5 1 directions stir with ice, strain into cocktail glass with lemon twist stir with ice, strain into cocktail glass with lemon twist stir with ice, strain into shot gless stir with ice, strain into cocktail glass serve over ice with straw pour hot orange juice in mug anc add peach nectar stir with ice, strain into cocktail glass serve over ice, stir well add juice to mug and top off with hot tea serve over ice with lime slice shake in cocktail glass, no ice drink_name Blackthorn Blue Moon Oh My Gosh Lime Fizz Kiss on the Lips Hot Gold Lone Tree Greyhound Indian Summer Bull Frog Soda and It main tonic water soda peach nectar Sprite cherry juice peach nectar soda soda apple juice iced tea soda amount] 1.5 1.5 1 1.5 2 3 1.5 1.5 2 1.5 2 easy_drinks second pineapple juice blueberry juice pineapple juice lime juice apricot nectar orange juice cherry juice grapefruit juice hot tea lemonade grape juice amount2 1 .75 1 75 7 6 .75 5 6 5 1 directions stir with ice, strain into cocktail glass with lemon twist stir with ice, strain into cocktail glass with lemon twist stir with ice, strain into shot gless stir with ice, strain into cocktail glass serve over ice with straw pour hot orange juice in mug anc add peach nectar stir with ice, strain into cocktail glass serve over ice, stir well add juice to mug and top off with hot tea serve over ice with lime slice shake in cocktail glass, no ice

Answer rating: 100% (QA)

As word document cannot be attached the screenshots are provided by num... View the full answer