title: Count multiple string and put the count of each string into column
body: <p>I'm really a newbie in sql and bigquery. In this case I use <code>bigquery-public-data.san_francisco_bikeshare.bikeshare_trips</code> dataset (image 1 and 2).</p>
  <p>I want to count total of subscirber_type, 'Subscriber' and 'Customer', and their average duration_sec.</p>
  <p>So the column I want to make it consist of:</p>
  <p><code>start_station name | total_Subscriber | total_nonSubscriber | avg_duration_Subscriber | avg_duration_nonSubscriber</code></p>
  <p>I hope you guys understand my question and could give me a help. Thanks in advance.</p>
  <p><a href="https://i.stack.imgur.com/tt41X.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tt41X.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/qDHnz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qDHnz.png" alt="enter image description here" /></a></p>