sql query to find sum of all rows and count of duplicates 
If data is in the following format,  
SID TID Tdatetime  QID QTotal  
100 1 01/12/97 9:00AM 66 110   
100 1 01/12/97 9:00AM 66 110  
100 1 01/12/97 10:00AM 67 110  
100 2 01/19/97 9:00AM 66 .  
100 2 01/19/97 9:00AM  66 110  
100 2 01/19/97 10:00AM  66 110  
100 3 01/26/97 9:00AM  68 120  
100 3 01/26/97 9:00AM  68 120  
110 1 02/03/97 10:00AM  68 110  
110 3 02/12/97 9:00AM  64 115  
110 3 02/12/97 9:00AM  64 115  
120 1 04/05/97 9:00AM  66 105  
120 1 04/05/97 10:00AM  66 105  

I would like to be able to write a query to sum the QTotal column for all rows and find the count of duplicate rows for the Tdatetime column.

The output would look like
Year 97 | 1340 | 4

Thanks for your help.

ARK
sql query to find sum of all rows and count of duplicates 
===

If data is in the following format,  
SID TID Tdatetime  QID QTotal  
100 1 01/12/97 9:00AM 66 110   
100 1 01/12/97 9:00AM 66 110  
100 1 01/12/97 10:00AM 67 110  
100 2 01/19/97 9:00AM 66 .  
100 2 01/19/97 9:00AM  66 110  
100 2 01/19/97 10:00AM  66 110  
100 3 01/26/97 9:00AM  68 120  
100 3 01/26/97 9:00AM  68 120  
110 1 02/03/97 10:00AM  68 110  
110 3 02/12/97 9:00AM  64 115  
110 3 02/12/97 9:00AM  64 115  
120 1 04/05/97 9:00AM  66 105  
120 1 04/05/97 10:00AM  66 105  

I would like to be able to write a query to sum the QTotal column for all rows and find the count of duplicate rows for the Tdatetime column.

The output would look like
Year 97 | 1340 | 4

Thanks for your help.

ARK