How to select multiple custom Firebase event parameters in BigQuery?
<p>I exported Firebase events to BigQuery and now I'm trying to select two parameters from a certain event. Here is the query for selecting one parameter:</p>

<pre><code>select event_dim.params.value.int_value as level_id
from [com_company_appname_ANDROID.app_events_20161210]
where event_dim.name = "level_replays_until_first_victory" and  event_dim.params.key = "level_id"
</code></pre>

<p>Both parameters are int values, name of the first parameter is <code>level_id</code>, and the second parameter is <code>count</code>. What I would like is to show is <code>level_id</code> in first column and <code>count</code> in second column.</p>