Practical 7

1 DELETE FROM orders_aj WHERE cnum LIKE (SELECT cnum FROM customer_aj WHERE cname LIKE 'Chirag');

         2 ROW(s) deleted.

2 UPDATE customer_aj SET rating=400 WHERE snum IN (SELECT snum FROM salesman_aj WHERE sname LIKE 'Piyush');

         2 ROW(s) updated.

3 UPDATE customer_aj SET rating = rating+100 WHERE city='Rome';

          2 ROW(s) updated.

5 UPDATE Salesman_aj SET SNAME='Gopal',CITY='Bombay',COMMISION=10 WHERE SNAME='Miti';

          1 ROW(s) updated.

6 UPDATE Salesman_aj SET COMMISION=COMMISION*2 WHERE CITY='London';

          1 ROW(s) updated.

7 UPDATE Customer_aj SET RATING=NULL WHERE CITY='London';
          2 ROW(s) updated.






5.UPDATE Salesman SET SNAME='Gopal',CITY='Bombay',COMMISSION=10 WHERE SNAME='Miti';
6.UPDATE Salesman SET COMMISSION=COMMISSION*2 WHERE CITY='London';
7.UPDATE Customers SET RATING=NULL WHERE CITY='London';