Oracle SQL Query: Help needed, Please.

[Quoted]
• I would appriciate your help on this Query:
  --
  
• The following table is created:
  --
  create table t1 ( emp_id number(2) ,enr date ,ter date );
  --
  
• Then the following rows were inserted into that table:
  --
  insert into t1 values (1, to_date('02-jan-97'), to_date('02-jan-98')); [Quoted] insert into t1 values (2, to_date('10-jan-97'), to_date('30-mar-97')); [Quoted] insert into t1 values (3, to_date('11-apr-97'), to_date('13-nov-97')); [Quoted] insert into t1 values (4, to_date('12-may-97'), to_date('13-nov-97')); [Quoted] insert into t1 values (5, to_date('20-nov-97'), to_date('14-jan-98')); [Quoted] insert into t1 values (6, to_date('30-jun-97'), to_date('15-feb-98')); commit; /* [Quoted] I want the following result from a single query:

month_year enrollments terminations
---------- ----------- -------------

[Quoted] jan-97		2		0
mar-97		0		1
apr-97		1		0
may-97		1		0
jun-97		1		0
nov-97		1		2
jan-98		0		2
feb-98		0		1

Thank you in advance.
*/

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 20 1998 - 00:00:00 CEST