Practical 1

--Practical one
1 SELECT ONUM,AMOUNT,ODATE FROM orders_aj;

ONUM    AMOUNT  ODATE
3011    9891.88 10-JUN-97
3010    1309.95 10-JUN-97
3008    4723    10-MAY-97
3007    75.75   10-APR-97
3009    1713.23 10-APR-97
3006    1098.16 10-MAR-97
3005    5160.45 10-MAR-97
3002    1900.1  10-MAR-97
3003    767.19  10-MAR-97
3001    18.69   10-MAR-97

2 SELECT * FROM customer_aj WHERE SNUM=1001;

CNUM    CNAME   CITY    RATING  SNUM
2006    Chirag  London  100 1001
2001    Harsh   London  100 1001

3 SELECT city,sname,snum,commision FROM salesman_aj ;

CITY        SNAME   SNUM    COMMISION
london      piyush  1001    12
surat       sejal   1002    13
london      miti    1004    11
Baroda      Rajesh  1007    15
NEW Delhi   Anand   1003    10

4 SELECT CNAME,RATING FROM customer_aj WHERE city='Surat';

CNAME   RATING
Chinmay 300
Lalit   200

5 SELECT DISTINCT snum FROM orders_aj;

SNUM
1007
1004
1001
1002
1003

6 SELECT * FROM orders_aj WHERE amount > 1000;

ONUM    AMOUNT  ODATE   CNUM    SNUM
3011    9891.88 10-JUN-97   2006    1001
3010    1309.95 10-JUN-97   2004    1002
3008    4723    10-MAY-97   2006    1001
3009    1713.23 10-APR-97   2002    1003
3006    1098.16 10-MAR-97   2008    1007
3005    5160.45 10-MAR-97   2003    1002
3002    1900.1  10-MAR-97   2007    1004

7 SELECT sname FROM salesman_aj WHERE city = 'London' AND commision > 10;

SNAME
Piyush
Miti


8 SELECT cname FROM customer_aj WHERE rating > 100 OR city='Rome';

CNAME
Pratik
Chinmay
Govind
Lalit
Gita

9 SELECT * FROM orders_aj WHERE odate='10-mar-97' AND snum>1006 AND amount>1000;


ONUM    AMOUNT  ODATE       CNUM    SNUM
3006    1098.16 10-MAR-97   2008    1007

10 SELECT * FROM orders_aj WHERE odate='3-oct-97' OR odate='4-oct-97' OR odate='6-oct-97';

no DATA found

11 SELECT cname FROM customer_aj WHERE cname LIKE 'C%';

CNAME
Chinmay
Chirag

12 SELECT cname FROM customer_aj WHERE cname LIKE 'A%G';

no DATA found


13 SELECT *FROM orders_aj WHERE amount = 0 OR amount = NULL;

no DATA found