RRDBMS retrieving information from the table Program code

PROGRAM:2 NAME:RUBUSC
DATE:09/07/2019 REGNO:20173081401230
tlo 16643

RETRIEVING INFORMATION FROM THE TABLE
DISPLAY ALL DEPARTMENT INFORMATION

SQL> select * from dept9:
DEPTID DEPTNAME DEPTHEAD LOCATION PHONE

01 sale suresh A13 8.967E+09
02 marketing Raj A15 8.968E+09
03 accounting Sam A12 9.968E+09
04 stock Nithya A14 8.968E+09
05 project Lal B 7.968E+09

DISPLAY ALL EMPLOYEE INFORMATION

SQL> select * from emp9;
EMPID NAME DATEOFJOIN DESIGNATION SEX DEPTID PROJID DATEOFBIRTH

scl Raj 12-JAN-08 manager male 01 prol 12-APR-85
sc2 Deva 09-JAN-08 clerk male 02 pro2 12-MAY -87
sc3 Lilly 09-MAR-09 c.Engr 03 pro3 20-MAR-87
sc4 Lallu 23-JUN-09 m.Engr male 04 pro4 10-MAR-88
sc5 Raj 03-JUN-09 MD imale 05 pros 30-MAR-87

DISPLAY THE DESIGNATION OF FEMALE EMPLOYEE

SQL> select empid.name.designation,projid from emp9 where sex='fin':
EMPID NAME DESIGNATION PROJID

sc3 Lilly c.Engr pro3A
DISPLAY THE EMPLOYEE DETAILS WITH BASIC PAY>5000
SQL> select * from paydetails9 where bpay>=5000:
EMPID EMPNAME BPAY

scl Deva 5000
sc2 Lilly 5000

DISPLAY THE EMPLOYEEDETAILS WITH BASIC PAY BETWEEN 5000 AND 6000
SQL>select empid.empname fro paydetails9 where bpay BETWEEN 5000 AND 6000;
EMPID EMPNAME

sel Deva
sc2 Lilly