Question

solve this question pls

Answer 1

Answer:

Here is the answer:

i)SELECT DNAME, DRINKCODE  

 FROM SOFTDRINK

 WHERE CALORIES > 120;

ii)SELECT DRINKCODE, DNAME, CALORIES

  FROM SOFTDRINK

  ORDER BY CALORIES;

iii)SELECT DENAME, PRICE

   FROM SOFTDRINK

   WHERE PRICE BETWEEN 12 and 18;

iv)UPDATE SOFTDRINK

  SET PRICE = PRICE + 0.10 * PRICE;