Re: What is wrong with this query?

ORA-00937 not a single-group group function Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.
Action: Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed.

MarkyG wrote:

> Try
> 
> SELECT distinct owner_id ||'  ' as "Owner ID", Count(distinct owner_id) as
> "Purch. Count", Sum(price) as "Purch. Count",
>        avg(price) as "Avg. Purch."
> FROM   purchase_tbl
> WHERE  purchase_date BETWEEN
>        TO_DATE('01-01-1998', 'mm-dd-yyyy') and
>        TO_DATE('12-31-2000', 'mm-dd-yyyy') 
> GROUP BY
>        owner_id;
> 
> m
> 
> sergiugp_at_aol.com (Sergiu gp) wrote in message news:<20020212060201.10819.00001049_at_mb-ba.aol.com>...
>