another confusing sql script - help me please!

curtmorehouse · #1 (**permalink**) 10-02-08, 19:51

I have a table with fields KEY and TYPE.
I want to display results for KEY and the AVERAGE of TYPE, ordered by TYPE and grouped by KEY, but only when KEY occurs 10 or more times in the table. If KEY does not occur 10 or more times, I don't want to see it.

Any help would be appreciated.

n_i · #2 (**permalink**) 10-02-08, 21:36

That definitely should include COUNT() and HAVING...

curtmorehouse · #3 (**permalink**) 10-02-08, 21:55

I got it to work after i looked up the HAVING feature.

Code:

select AVG($type), $key from database.table
group by $key HAVING COUNT($key) > 10
order by AVG($type) $order, $key

Internet Services

Web Development

Digital Marketing

Consumer Tech