Average entries per day in dataset
<p>I have the following table</p>

<pre><code>Name|Date      |Activity
Ann |2016-01-01|Sleep
Ann |2016-01-01|Walk
Pete|2016-01-01|Sleep
Pete|2016-01-01|Walk
Pete|2016-01-01|Swim
</code></pre>

<p>This table goes on for the whole year and for more than 100 people. I want to get the average amount of activities for each person. Like </p>

<pre><code>Ann |3.3, 
Pete|4.2 
</code></pre>

<p>that says that Ann did 3.3 activities per day in the dataset timerange. </p>

<p>What I tried yet is</p>

<pre><code>Select count(Date), Name from table
group by date, name
</code></pre>

<p>But when I run this I get more than one entry for each name. Could anyone help me get this query done?</p>