I have a table as below
Reading (ReadingNo Int, Readdate Date, ReaderID Int)
I need to display a result of no.of reading read by each reader during the current month.
I tried with the below:
Select Count(*), to_char(Trunc(ReadDate,'mm'),'Month') Month From Reading Group By trunc (ReadDate,'mm');
Result = Number of reading done each month and
Select COUNT(*), ReaderID From Reading Group By ReaderID;
Result = Number of reading done by reader
However I need query that can nest this 2 statement to provide me with a result of the number of reading done by each reader during the current month.