Tag: google-bigquery

I am more of beginner with sql but would like some help on which statement would be best to use for my query. So I have an app that has test data, because the score could be 90 or be 85.6 the values are in different columns – former in int.value, latter in double.value. I need to merge the two

I have two tables table 1 (log_audit table) table 2 is (final_log table) table 1 data looks like below table 2 data looks like below Here user “D” actual resolver of the customer ticket. …

I have a problem with GROUP BY one column and choose second column that is string depends on Count number from column three. So I have a table with ID’s in column one, string in column two and Count in column three. I have ordered that by ID’s and Count descending. Most of the ID’s are uniqu…

I have the following data which I want to group into seconds per day in BigQuery. Source Table: +————–+———————+———————+ | ComputerName | StartDatetime | EndDatetime | +————…

My table looks like this: There’s one more column named “user_pseudo_id” which is unique id for users. I want to take sum of event_params.key = ‘engagement_time_msec’ for user_pseudo_id who have done event_name = ‘yt_event’. Also, event_params.key = ‘engagement_…