I have managed to generate a single column based on multiple counts with different prefixes, as detailed here.
But now I want to update an existing BigQuery column with that value (my_label) and I am stumped as to how to.
I thought maybe a cte but I don't know how to get the right row within the cte.
