If I have a field jsonCol which has list of json objects, for example: [{'name': 'fieldA', 'enum': 'someValA'}, {'name': 'fieldB', 'enum': 'someValB'}, {'name': 'fieldC', 'enum': 'someValC'}] Another row may look like: [{'name': 'fieldA', 'enum': 'someValA'}, {'name': 'fieldC', 'enum': 'someValC'}] How…
I'm using redash and my table looks something like this. I'm just learning sql. This is very advanced for me. I searched many questions, no queries worked for me |user_id | long | lat | |1 |31.000|26.000| |2 |30.000|25,000| |3…
Let's say the table looks like this: user id date Amount 123 2022/11/01 5 456 2022/11/02 6 789 2022/11/03 8 123 2022/11/02 9 456 2022/11/04 6 789 2022/11/05 8 I want to calculate the sum of the very last transaction…
I have a problem I'm trying to resolve. I'd love to get your ideas or help with the method I have in my mind. I created a good analogy for it: I need to tag each record in a table…