Hi I have the following two table structures: create table parent ( parent_id number not null, class varchar2(1) ); create table child ( child_id number not null, parent_id number not null, date_done ); I want to retrieve the number of child records for each of class A and class B of the parent records, grouped by date_done. E.G. -
