Divide Average of a Category by Average of the all categories
<p>I have a SQL database that I essentially want to take the average of a group and divide by the average of the total. For example:</p>

<pre><code>Fruit        Number_of_Seeds
Rasp            50
Rasp            65
Straw           200
Blue            20
Straw           250
</code></pre>

<p>So I want to get something of the form:</p>

<pre><code>Fruit        Avg Seeds of Fruit / Avg of All Fruits 
Rasp                  =((50+65)/2)/((50+65+200+20+250)/5)     
Straw
Blue
</code></pre>

<p>I already have code to get the average seeds for fruit but how would I incorporate the denominator if I already have a group by Fruit statement?</p>

<p>Hope this makes sense. Thanks</p>