Question

answer this fast please.
please can someone help me.
please see the picture below and answer.

Answer 1

Answer:

(i)

mysql> select productno,productname,price*quantity as total from product;

(ii)

mysql> select *from product

         > where price<50;

Explanation:

(I)

Multiply two attributes price and quantity and display with alias total.

(ii)

where clause used to write condition