Question : Similar to this problem: Using start and end event logs to create a table/view containing spans between the […]
Tag: google-bigquery
How to convert timestamp to date & time
Question : I am currently working on bigquery(standard sql), where I have a timestamp field which I want to convert […]
Restructure create and delete events on rows into single table
Question : Similar to this problem: Using start and end event logs to create a table/view containing spans between the […]
Calculate Percentage with JOINS and original value
Question : I need your help. I’m trying to calculate percentages by using results from JOINING divided by the original […]
why there is no performance differences if I use where clause inside of inner join?
Question : Basically I have two different types of query in BQ. the first one: select q2.name, q1.* , q2.val1 […]
Count missing values across columns and join back to original table
Question : Here is the table: I want to count the missing values across each row for t1, t2, t3,…, […]
Counting unique records across 2 columns and computing a score based on boolean values
Question : I have a table that looks like this in Google Big Query: custID InteractionDate Purchased? Sales 1 20150312 […]
Count missing values across columns and join back to original table
Question : Here is the table: I want to count the missing values across each row for t1, t2, t3,…, […]
Select first and last row based on each user id mysql
Question : I want to select every first and last event of every user id, if no first event exists,then […]
Select only those rows based on specific condition of user id
Question : Below is an example of child’s activity table. I only want to see all rows after 1st Tv […]