easy drinks drinkm Blockthorn second irection onic water1 pineapple jcewthce, st

Question

easy drinks drinkm Blockthorn second irection onic water1 pineapple jcewthce, strain into cocktail gla w soda 15 blueberry jvice 75wi ice,strain into cocktail glas wih lemon wis ir with ice, strain into shot gless sir with ice, strain into cocktail glass erve over ice wih sw peach necto Sprite Oh My Gosh -Fizz ime Fiaa 1.5 ime jvice 75 ss on the Lips cherry jvice2 apricel necor Hot Gold peach nector3 e juicePour hot orange juice in mug an ad peach necor Lone Tree sode 1.5 cherry jice 75 Greyhound soda 1.5 erve over icesi ndian Summerapple jice hol tea lemonode grope vice lea Bull Frog Sode and ced tea 1.5 serve over ice with ime slice hoke in cocktail gloss, no i

Explanation / Answer

To create the Drinks database, We can use this command:

CREATE DATABASE Drinks;

We can select our database with the command:

USE Drinks;

1.CREATE TABLE easy_drinks(drink_name varchar(20), main varchar(20),amount1 number(10), second varchar(20), amount2 number(10), directions varchar(200));

2. INSERT INTO easy_drinks (drink_name,main,amount1,second,amount2,directions) VALUES (‘Blue Moon’,’soda’,1.5,’blueberry juice’,0.75,

’stir with ice strain into cocktail glass with lemon twist’);

Similarly we can insert other tuples also

3. SELECT main,second , directions FROM easy_drinks;

4. SELECT drink_name,amount2 FROM easy_drinks WHERE second LIKE ‘%juice’ ORDER BY drink_name ASC;

5. SELECT drink_name,directions FROM easy_drinks WHERE amount1 > 1;

6. SELECT * FROM easy_drinks WHERE main = “soda”;

7. SELECT drink_name FROM easy_drink ORDER BY drink_name DESC;

8. SELECT drink_name,amount2,second,directions FROM easy_drinks WHERE main = “soda”;

9. DESC easy_drinks;

10. SELECT drink_name, directions FROM drinks_name WHERE main LIKE ‘%tea’;

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.