Do some basic SQL statement.....I DON'T KNOW HOW TO DO THAT..I NEED HELP...PLEASE HELP ME.

 /* (1) */
create table IF NOT EXISTS  `ORDER` ( CNO int(3) NOT NULL
                                  , GNO int(3) NOT NULL
                                  , NUM int(3)
                                  , PRIMARY KEY (CNO, GNO) 
                                  , FOREIGN KEY(CNO) REFERENCES COMPANY(CNO) 
                                  , FOREIGN KEY(GNO) REFERENCES GIFT(GNO) );

/* (2) */
CREATE VIEW `ORDER_DETAILS` AS
SELECT O.CNO, C.CNAME, G.GNAME, O.NUM
  FROM  `ORDER` O
       INNER JOIN COMPANY C ON (O.CNO = C.CNO) 
       INNER JOIN GIFT G ON (O.GNO = G.GNO);
       
/* (3) */
ALTER TABLE COMPANY
DROP COLUMN ZIPCODE;
       
       
/* (4) */
CREATE INDEX idx_cname
ON COMPANY (CNAME);

/* (5) */
SELECT CNO
FROM ORDER_DETAILS
WHERE NUM > 2000;

/* (6) */
SELECT CNO, CNAME
FROM ORDER_DETAILS
WHERE GNAME in ('coffee', 'green tea');

/* (7) */
select GNAME
from GIFT
where price > 100;

/* (8) */
delete gift
where gname = 'green tea';

commit;


/* (9) */
update GIFT
  set price = 1.01 * price;

commit;

/* (10) */
GRANT SELECT ON `ORDER` TO U5;