Dbms Assignment No. 1

TABLE NO. – 1: PROGRAMMER NAME ANAND ALTAF JAGADESH JULIANA KAMALA MARY NELSON PATRICK QADIR RAMESH REBECCA REMITHA REVATHI VIJAYA

DOB 21-Apr-66 2-Jul-64 6-Oct-70 31-Jan-68 30-Oct-68 24-Jun-70 11-Sep-65 19-Nov-65 31-Aug-65 3-May-67 1-Jan-67 19-Apr-70 2-Dec-69 14-Dec-65

DOJ 21-Apr-92 13-Nov-90 4-Oct-94 21-Apr-90 2-Jan-92 1-Feb-91 11-Oct-89 21-Apr-90 21-Apr-93 28-Feb-91 1-Dec-90 20-Apr-93 2-Jan-92 2-May-92

S M M M F F F M M M M F F F F

PROF1 PASCAL CLIPPER ORACLE COBOL C C++ COBOL PASCAL ASSEMBLY PASCAL BASIC C PASCAL FOXPRO

PROF2 BASIC COBAL JAVA DBASE DBASE ORACLE DBASE CLIPPER C DBASE COBOL ASSEMBLY BASIC C

SALARY 3200 2800 4100 3000 2900 4500 2500 2800 3000 3200 2500 3600 3700 3500

TABLE NO. – 2: SOFTWARE NAME ANAND ANAND JAGADESH JAGADESH JULIANA KAMALA MARY MARY MARY PATRICK QADIR QADIR RAMESH RAMESH

TITLE PARACHUTES VIDEO TITLING PACK SERIAL LINK UTILITY SHARES MANAGEMENT INVENTORY CONTROL PAYROLL PACKAGE FINANCILA ACC S/W CODE GENERATOR READ ME GRAPHIC EDITOR BOMBS AWAY VACCINES HOTEL MANAGEMENT DEAD LEE

© Created by Arun Pandey System

DEV_IN BASIC PASCAL JAVA ORACLE COBOL DBASE ORACLE C C++ PASCAL ASSEMBLY C DBASE PASCAL

-1-

SCOST 399.95 7500 800 3000 3000 9000 18000 4500 300 750 499.95 1900 12000 99.95

DCOST 6000 10000 7500 12000 3500 20000 85000 20000 1200 5000 530 3400 35000 4500

SOLD 43 9 10 14 0 7 4 23 94 11 114 21 4 73

Data Base Management

TABLE NO. – 3: STUD IES NAME ANAND ALTAF JAGADESH JULIANA KAMALA MARY NELSON PATRICK QADIR RAMESH REBECCA REMITHA REVATHI VIJAYA

SPLACE SABHARI CCIT SSIL BITS PRAGATHI SABHARI PRAGATHI PRAGATHI APPLE SABHARI BRILLIANT BOPS SABHARI BOPS

COURS PGDCA DCA DCA DCA DCP PGDCA DAP DCAP HOCP PGDCA DCA DCS DAP DCA

CCOST 4500 7200 3500 22000 5000 4500 6200 5200 14000 4500 11000 6000 5000 48000

Q UERY SHEET NO . 1 1. Find the SELLING COST AVERAGE for the package developed in PASCAL? Sol. SELECT AVG(SCOST) FROM SOFTWARE WHERE DEV_IN='PASCAL'; AVG(SCOST) 2362.4875

2. Display the NAMES and AGES of all the programmers? Sol. SELECT NAME,(ROUND((MONTHS_BETWEEN(SYSDATE,DOB))/12))AGE FROM PROGRAMMER; NAME

AGE

ANAND ALTAF JAGADESH JULIANA KAMALA MARY NELSON PATRICK QADIR RAMESH REBECCA REMITHA REVATHI VIJAYA

© Created by Arun Pandey System

43 45 38 41 40 39 43 43 44 42 42 39 39 43

-2-

Data Base Management

3. Display the NAMES of those who have done the DAP course? Sol. SELECT NAME FROM STUDIES WHERE COURSE='DAP'; NAME NELSON REVATHI

4. What is the HIGHEST number of copies sold by a package? Sol. SELECT MAX(SOLD) FROM SOFTWARE; MAX(SOLD) 114

5. Display the NAMES and DATE OF BIRTH of all the programmers born in JANUARY? Sol. SELECT NAME,DOB FROM PROGRAMMER WHERE TO_CHAR(DOB,'MON')='JAN'; NAME

DOB

JULIANA REBECCA

31-Jan-68 1-Jan-67

6. Display the LOWEST course fee? Sol. SELECT MIN(CCOST) FROM STUDIES; MIN(CCOST) 3500

7. How many programmers have done the PGDCA course? Sol. SELECT COUNT(NAME) FROM STUDIES WHERE COURSE='PGDCA'; COUNT(NAME) 3

8. How much revenue has been earned through sale of package in C? Sol. SELECT SUM((SCOST*SOLD)-DCOST) FROM SOFTWARE WHERE DEV_IN='C'; SUM((SCOST*SOLD)-DCOST) 156675

9. Display the details of the SOFTWARE developed by RAMESH? Sol.

SELECT

TITLE,DEV_IN,SCOST,DCOST,SOLD

FROM

SOFTWARE

WHERE

NAME='RAMESH'; TITLE HOTEL MANAGEMENT DEAD LEE

DEV_IN DBASE PASCAL

SCOST 12000 99.95

DCOST 35000 4500

SOLD 4 73

10. How many programmers studied at SABHARI? Sol. SELECT COUNT(SPLACE) FROM STUDIES WHERE SPLACE='SABHARI'; COUNT(SPLACE) 4

© Created by Arun Pandey System

-3-

Data Base Management

11. Display the details of PACKAGES whose sale CROSSED the 20000 mark. Sol. SELECT * FROM SOFTWARE WHERE SCOST*SOLD>=20000; NAME ANAND JAGADESH KAMALA MARY MARY MARY QADIR QADIR RAMESH REMITHA REVATHI

TITLE VIDEO TITLING PACK SHARES MANAGEMENT PAYROLL PACKAGE FINANCILA ACC S/W CODE GENERATOR READ ME BOMBS AWAY VACCINES HOTEL MANAGEMENT PC UTILITIES QUIZ MASTER

DEV_IN PASCAL ORACLE DBASE ORACLE C C++ ASSEMBLY C DBASE C BASIC

SCOST 7500 3000 9000 18000 4500 300 499.95 1900 12000 725 3200

DCOST 10000 12000 20000 85000 20000 1200 530 3400 35000 5000 2100

SOLD 9 14 7 4 23 94 114 21 4 51 15

12. Find the NUMBER OF COPIES which should be sold in order to recover the DEVELOPMENT COST of each package. Sol. SELECT TITLE,(ROUND((DCOST/SCOST),0)) AS RECOVER FROM SOFTWARE; TITLE PARACHUTES VIDEO TITLING PACK SERIAL LINK UTILITY SHARES MANAGEMENT INVENTORY CONTROL PAYROLL PACKAGE FINANCILA ACC S/W CODE GENERATOR READ ME GRAPHIC EDITOR BOMBS AWAY VACCINES HOTEL MANAGEMENT DEAD LEE PC UTILITIES TSR HELP PACKAGE HOTEL MANAGEMENT QUIZ MASTER ISK EDITOR

RECOVER 15 1 9 4 1 2 5 4 4 7 1 2 3 45 7 2 68 1 1

13. Display the details of packages for WHICH development cost have been recovered. Sol. SELECT * FROM SOFTWARE WHERE (SCOST*SOLD)>DCOST; NAME ANAND ANAND JAGADESH JAGADESH

TITLE PARACHUTES VIDEO TITLING PACK SERIAL LINK UTILITY SHARES MANAGEMENT

© Created by Arun Pandey System

-4-

DEV_IN BASIC PASCAL JAVA ORACLE

SCOST 399.95 7500 800 3000

DCOST 6000 10000 7500 12000

Data Base Management

SOLD 43 9 10 14

KAMALA MARY MARY PATRICK QADIR QADIR RAMESH RAMESH REMITHA REMITHA REVATHI VIJAYA

PAYROLL PACKAGE CODE GENERATOR READ ME GRAPHIC EDITOR BOMBS AWAY VACCINES HOTEL MANAGEMENT DEAD LEE PC UTILITIES TSR HELP PACKAGE QUIZ MASTER ISK EDITOR

DBASE C C++ PASCAL ASSEMBLY C DBASE PASCAL C ASSEMBLY BASIC C

9000 4500 300 750 499.95 1900 12000 99.95 725 2500 3200 900

20000 20000 1200 5000 530 3400 35000 4500 5000 6000 2100 700

7 23 94 11 114 21 4 73 51 6 15 6

14. What is the price of the costliest software developed in BASIC? Sol. SELECT MAX(SCOST)FROM SOFTWARE WHERE DEV_IN='BASIC'; MAX(SCOST) 3200

15. How many packages were developed in DBASE? Sol. SELECT COUNT(DEV_IN) FROM SOFTWARE WHERE DEV_IN='DBASE'; COUNT(DEV_IN) 2

16. How many programmers studied at PRAGATHI? Sol. SELECT COUNT(NAME) FROM STUDIES WHERE SPLACE='PRAGATHI'; COUNT(NAME) 3

17. How many programmers paid 5000 to 10000 for their COURSE? Sol. SELECT COUNT(NAME) FROM STUDIES WHERE CCOST BETWEEN 5000 AND 10000; COUNT(NAME) 6

18. What is the AVERAGE course fee? Sol. SELECT AVG(CCOST) FROM STUDIES; AVG(CCOST) 10471.4286

19. Display the

DETAILS of programmers knowing C?

Sol. SELECT * FROM PROGRAMMER WHERE PROF1='C' OR PROF2='C'; NAME KAMALA QADIR REMITHA VIJAYA

DOB 30-Oct-68 31-Aug-65 19-Apr-70 14-Dec-65

© Created by Arun Pandey System

DOJ 2-Jan-92 21-Apr-93 20-Apr-93 2-May-92

-5-

S F M F F

PROF1 C ASSEMBLY C FOXPRO

PROF2 DBASE C ASSEMBLY C

SALARY 2900 3000 3600 3500

Data Base Management

20. How many programmers know either COBOL or PASCAL? Sol. SELECT COUNT(NAME)FROM PROGRAMMER WHERE PROF1='COBOL' OR PROF1='PASCAL' OR PROF2='COBOL' OR PROF2='PASCAL'; COUNT(NAME) 7

21. How many programmers DON’T know PASCAL and C? Sol. SELECT COUNT(NAME) FROM PROGRAMMER WHERE(PROF1!='C' AND PROF2! ='PASCAL')OR(PROF1!='PASCAL' AND PROF2!='C'); COUNT(NAME) 14 22. How old is the OLDEST male Programmers? Sol.

SELECT

DISTINCT

ROUND(MONTHS_BETWEEN(SYSDATE,DOJ)/12)

AS

OLDEST_C_PROGRAMMER FROM PROGRAMMER WHERE DOJ IN((SELECT DOJ FROM PROGRAMMER WHERE PROF1='C' AND SEX='M')UNION(SELECT DOJ FROM PROGRAMMER WHERE PROF2='C' AND SEX='M')); OLDEST_C_PROGRAMMER 16 23. What is the AVERAGE age of female Programmers? Sol.

SELECT

ROUND(AVG(ROUND(MONTHS_BETWEEN(SYSDATE,DOB)/12)))

AS

AVERAGE_AGE_FEMALE FROM PROGRAMMER WHERE SEX='F'; AVERAGE_AGE_FEMALE 40 24. CALCULATE the experience in years for each programmers and display along with the names in DESCENDING order. Sol. SELECT NAME,ROUND(MONTHS_BETWEEN(SYSDATE,DOJ)/12) AS EXPERIENCE FROM PROGRAMMER ORDER BY NAME DESC; NAME

EXPERIENCE

VIJAYA REVATHI REMITHA REBECCA RAMESH QADIR PATRICK NELSON MARY KAMALA JULIANA JAGADESH ANAND ALTAF

© Created by Arun Pandey System

17 17 16 18 18 16 19 19 18 17 19 14 17 18

-6-

Data Base Management

25. Who are the programmers who celebrate their Birthday’s during the CURRENT MONTH? Sol. SELECT NAME FROM PROGRAMMER WHERE TO_CHAR (SYSDATE,'MON') = TO_CHAR (DOB,'MON'); CURRENT MONTH IN SYSTEM IS MARCH: no rows selected AFTER CHANGING THE CURRENT MONTH TO JAN: NAME JULIANA REBECCA

26. How many female programmers are there? Sol. SELECT COUNT(DISTINCT NAME) AS NO_FEMALE_PROGRAMMERS FROM PROGRAMMER WHERE SEX='F'; NO_FEMALE_PROGRAMMERS 7

27. What are the languages known by the male programmers? Sol. (SELECT DISTINCT PROF1 FROM PROGRAMMER WHERE SEX='M') UNION (SELECT DISTINCT PROF2 FROM PROGRAMMER WHERE SEX='M'); PROF1 ASSEMBLY BASIC C CLIPPER COBAL COBOL DBASE JAVA ORACLE PASCAL 28. What is the AVERAGE salary? Sol. SELECT AVG(SALARY) AS AVERAGE_SALARY FROM PROGRAMMER; AVERAGE_SALARY 3235.71429

29. How many people draw 2000 to 4000? Sol. SELECT COUNT(DISTINCT NAME) AS NO_OF_PEOPLE_BET_4000_2000 FROM PROGRAMMER WHERE SALARY<=4000 AND SALARY>=2000; NO_OF_PEOPLE_BET_4000_2000 12

© Created by Arun Pandey System

-7-

Data Base Management

30. Display the details of those WHO DON’T know CLIPPER, COBOL, and PASCAL? Sol. (SELECT NAME,DOB,DOJ,SEX,SALARY FROM PROGRAMMER WHERE PROF1!='COBOL') INTERSECT(SELECT NAME,DOB,DOJ,SEX,SALARY FROM PROGRAMMER WHERE PROF2! ='COBOL') INTERSECT(SELECT NAME,DOB,DOJ,SEX,SALARY FROM PROGRAMMER WHERE PROF1 != 'CLIPPER') INTERSECT (SELECT NAME,DOB,DOJ,SEX,SALARY FROM PROGRAMMER WHERE PROF2!='CLIPPER')INTERSECT(SELECT NAME,DOB,DOJ,SEX,SALARY FROM PROGRAMMER WHERE PROF1! ='PASCAL')INTERSECT(SELECT NAME,DOB,DOJ,SEX,SALARY FROM PROGRAMMER WHERE PROF2!='PASCAL'); NAME

DOB 6-Oct-70 30-Oct-68 24-Jun-70 31-Aug-65 19-Apr-70 14-Dec-65

JAGADESH KAMALA MARY QADIR REMITHA VIJAYA

DOJ 4-Oct-94 2-Jan-92 1-Feb-91 21-Apr-93 20-Apr-93 2-May-92

S M F F M F F

SALARY 4100 2900 4500 3000 3600 3500

31. How many female programmers knowing C are above 24 years of age? Sol.

SELECT

COUNT(DISTINCT

NAME)

AS

NO_FEMALE_MORE_24

FROM

PROGRAMMER WHERE ROUND((MONTHS_BETWEEN(SYSDATE,DOB))/12) >24 AND SEX='F'; NO_FEMALE_MORE_24 7

32. Who are the programmers who will be celebrating their Birthday’s within a WEEK? Sol. SELECT NAME FROM PROGRAMMER WHERE TO_CHAR(SYSDATE,'MON') = TO_CHAR(DOB,'MON')

AND

(TO_CHAR(DOB,'DD')-TO_CHAR(SYSDATE,'DD'))

BETWEEN 0 AND 7; CURRENT MONTH IS MARCH AND DATE IS 20: no rows selected CHANGING THE MONTH TO APR: NAME ANAND

33. Display the details of those with LESS than a Year’s EXPERIENCE. Sol. SELECT * FROM PROGRAMMER WHERE ROUND (MONTHS_BETWEEN (SYSDATE, DOJ)/12) >1; NAME ANAND ALTAF JAGADESH JULIANA KAMALA MARY

DOB 21-Apr-66 2-Jul-64 6-Oct-70 31-Jan-68 30-Oct-68 24-Jun-70

© Created by Arun Pandey System

DOJ 21-Apr-92 13-Nov-90 4-Oct-94 21-Apr-90 2-Jan-92 1-Feb-91

-8-

S M M M F F F

PROF1 PASCAL CLIPPER ORACLE COBOL C C++

PROF2 BASIC COBAL JAVA DBASE DBASE ORACLE

SALARY 3200 2800 4100 3000 2900 4500

Data Base Management

NELSON PATRICK QADIR RAMESH REBECCA REMITHA REVATHI VIJAYA

11-Sep-65 19-Nov-65 31-Aug-65 3-May-67 1-Jan-67 19-Apr-70 2-Dec-69 14-Dec-65

11-Oct-89 21-Apr-90 21-Apr-93 28-Feb-91 1-Dec-90 20-Apr-93 2-Jan-92 2-May-92

M M M M F F F F

COBOL PASCAL ASSEMBLY PASCAL BASIC C PASCAL FOXPRO

DBASE CLIPPER C DBASE COBOL ASSEMBLY BASIC C

2500 2800 3000 3200 2500 3600 3700 3500

34. Display the details of those who will be COMPLETING 2 years of service this year. Sol.

SELECT

*

FROM

PROGRAMMER

WHERE

ROUND

(MONTHS_BETWEEN

(SYSDATE,DOJ) /12) =2; Current date of system = 20.03.2009 No Rows Selected. Date changes to 20.03.1994 NAME ANAND KAMALA REVATHI VIJAYA

DOB 21-Apr-66 30-Oct-68 2-Dec-69 14-Dec-65

DOJ 21-Apr-92 2-Jan-92 2-Jan-92 2-May-92

S M F F F

PROF1 PASCAL C PASCAL FOXPRO

PROF2 BASIC DBASE BASIC C

SALARY 3200 2900 3700 3500

35. CALCULATE the amount TO BE recovered for those packages whose development cost has not yet been recovered. Sol. SELECT TITLE,((DCOST)-(SCOST*(ROUND((DCOST/SCOST),0)))) AS RECOVER FROM SOFTWARE WHERE DCOST>(SCOST*(ROUND((DCOST/SCOST),0))); TITLE PARACHUTES VIDEO TITLING PACK SERIAL LINK UTILITY INVENTORY CONTROL PAYROLL PACKAGE CODE GENERATOR BOMBS AWAY DEAD LEE TSR HELP PACKAGE HOTEL MANAGEMENT

RECOVER 0.75 2500 300 500 2000 2000 30.05 2.25 1000 200

36. List the packages, WHICH HAVE NOT BEEN sold so far. Sol. SELECT TITLE AS NOT_YET_SOLD FROM SOFTWARE WHERE SOLD=0; NOT_YET_SOLD INVENTORY CONTROL

37. Find out the COST of the software developed by MARY. Sol. SELECT TITLE,SCOST AS SOFTWARE_COST,DCOST AS DEVELOPING_COST FROM SOFTWARE WHERE NAME='MARY';

© Created by Arun Pandey System

-9-

Data Base Management

TITLE FINANCILA ACC S/W CODE GENERATOR READ ME

SOFTWARE_COST 18000 4500 300

DEVELOPING_COST 85000 20000 1200

38. Display the institute name FROM the Studies table WITHOUT DUPLICATES. Sol. SELECT DISTINCT SPLACE AS INSTITUE_NAME FROM STUDIES; INSTITUE_ APPLE BITS BOPS BRILLIANT CCIT PRAGATHI SABHARI SSIL

39. How many different courses are mentioned in the studies table? Sol. SELECT

COUNT(DISTINCT COURSE) AS NO_DIFFERENT_COURSE

FROM

STUDIES; NO_DIFFERENT_COURSE 7 40. Display the names of the programmers WHOSE names contain 2 OCCURRENCE of the letter ‘A’. Sol. SELECT NAME FROM PROGRAMMER WHERE NAME LIKE '%A%A%' AND NAME NOT LIKE '%A%A%A%'; NAME ANAND ALTAF JAGADESH JULIANA VIJAYA

41. Display the names of programmers WHOSE names contain UPTO 5 Characters. Sol. SELECT NAME FROM PROGRAMMER WHERE LENGTH(NAME)<=5; NAME ANAND ALTAF MARY QADIR

42. How many female programmers knowing COBOL have more than 2 years Experience?

© Created by Arun Pandey System

- 10 -

Data Base Management

Sol.

SELECT

COUNT(DISTINCT

NAME)

AS

NO_FEMALE_EXPERIENCE

FROM

PROGRAMMER WHERE NAME IN((SELECT NAME FROM PROGRAMMER WHERE SEX='F' AND PROF1='COBOL')UNION(SELECT NAME FROM PROGRAMMER WHERE SEX='F' AND PROF2='COBOL') ); NO_FEMALE_EXPERIENCE 2

43. What is the LENGTH of the shortest name in the programmer table? Sol. SELECT MIN(LENGTH(NAME))AS MINIMUM_NAME FROM PROGRAMMER; MINIMUM_NAME 4

44. What is the AVERAGE development cost of a package developed in COBOL? Sol. SELECT AVG(DCOST) AS AVERAGE_DEV_COST_COBOL FROM SOFTWARE WHERE DEV_IN='COBOL'; AVERAGE_DEV_COST_COBOL 3500 45. Display the name, sex, DOB(DD/MM/YY Format), DOJ(DD/MM/YY Format) for all the programmers WITHOUT using conversion function. Sol. SELECT NAME,SEX,TO_CHAR(DOB,'DD-MON-YY') DOB,TO_CHAR(DOJ,'DD-MONYY') DOJ FROM PROGRAMMER; NAME ANAND ALTAF JAGADESH JULIANA KAMALA MARY NELSON PATRICK QADIR RAMESH REBECCA REMITHA REVATHI VIJAYA

S M M M F F F M M M M F F F F

DOB

DOJ 21-Apr-66 2-Jul-64 6-Oct-70 31-Jan-68 30-Oct-68 24-Jun-70 11-Sep-65 19-Nov-65 31-Aug-65 3-May-67 1-Jan-67 19-Apr-70 2-Dec-69 14-Dec-65

21-Apr-92 13-Nov-90 4-Oct-94 21-Apr-90 2-Jan-92 1-Feb-91 11-Oct-89 21-Apr-90 21-Apr-93 28-Feb-91 1-Dec-90 20-Apr-93 2-Jan-92 2-May-92

46. What is amount paid in salaries of the male programmers who do not know COBOL.

© Created by Arun Pandey System

- 11 -

Data Base Management

Sol. SELECT NAME,SALARY FROM PROGRAMMER WHERE SEX='M' AND NAME NOT IN ((SELECT NAME FROM PROGRAMMER WHERE PROF1='COBOL')UNION(SELECT NAME FROM PROGRAMMER WHERE PROF2='COBOL')); NAME

SALARY

ANAND ALTAF JAGADESH PATRICK QADIR RAMESH

3200 2800 4100 2800 3000 3200

47. Who are the programmers who were born on the last day of the month. Sol. SELECT NAME FROM PROGRAMMER WHERE DOB=LAST_DAY(DOB); NAME JULIANA QADIR 48. Display the title, scost, dcost, and difference between scost and dcost in descending order of difference? Sol.

SELECT

NAME,SCOST,DCOST,

DCOST-SCOST

AS

DIFFERENCE

FROM

SOFTWARE ORDER BY DIFFERENCE DESC; NAME REVATHI MARY RAMESH MARY KAMALA JAGADESH JAGADESH ANAND RAMESH REMITHA PATRICK REMITHA ANAND QADIR MARY JULIANA QADIR VIJAYA REVATHI

SCOST

DCOST

1100 18000 12000 4500 9000 3000 800 399.95 99.95 725 750 2500 7500 1900 300 3000 499.95 900 3200

DIFFERENCE 73900 67000 23000 15500 11000 9000 6700 5600.05 4400.05 4275 4250 3500 2500 1500 900 500 30.05 -200 -1100

75000 85000 35000 20000 20000 12000 7500 6000 4500 5000 5000 6000 10000 3400 1200 3500 530 700 2100

49. Display the name of the package whose names contain more than 1 word? Sol. SELECT TITLE FROM SOFTWARE WHERE TITLE LIKE '_% _%'; TITLE

© Created by Arun Pandey System

- 12 -

Data Base Management

VIDEO TITLING PACK SERIAL LINK UTILITY SHARES MANAGEMENT INVENTORY CONTROL PAYROLL PACKAGE FINANCILA ACC S/W CODE GENERATOR READ ME GRAPHIC EDITOR BOMBS AWAY HOTEL MANAGEMENT DEAD LEE PC UTILITIES TSR HELP PACKAGE HOTEL MANAGEMENT QUIZ MASTER ISK EDITOR

50. Display the name, DOB, DOJ, of THOSE MONTH of BIRTH and MONTH of JOINING are the same? Sol. SELECT NAME, DOB,DOJ FROM PROGRAMMER WHERE TO_CHAR(DOB,'MON') =TO_CHAR(DOJ,'MON'); NAME

DOB

ANAND JAGADESH REMITHA

© Created by Arun Pandey System

21-Apr-66 6-Oct-70 19-Apr-70

- 13 -

DOJ 21-Apr-92 4-Oct-94 20-Apr-93

Data Base Management