Question

(a) write a command to insert a new record

(b) write a query to display records whose price is from _____and_____

(c) write s query to display records in accending or decending order

just give an example, please give the right answer, I have exam morning please ASAP​

Answer 1

Examples

a). INSERT INTO EMP VALUES ( "1" , "ABC");

b). SELECT * FROM EMP WHERE price BETWEEN ____ AND _____;

c).SELECT * FROM EMP ORDER BY ASC;

ASC =ASCENDING

DESC = DESCENDING

HERE

EMP = TABLE NAME