You need to: select from employers join to students group by count Then join that query to fees group by avg Seriously if this is beyond you then withdraw from the course. Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP