Probably it's super simple but i've been stuck some hours on this. I have a column called "Publish_Date" which is a varchar, but my date shows like this: 17.01.11 (year.day.month) and I want to convert it to a date (at…
cust_id state 1 CA 2 IL 3 SC 1 PA 3 IA 4 MO 5 VA 4 NY Can any one please advise on SQL Query that return the cust_id that belong to two states as below: The output should…
I'm writing a script to create 5 tables, but cannot seem to get the SQL DDL part of the statement to work. I get a syntax error " unexpected 'table' ", and I've tried the SQL statement with execute immediate…
I have two SQL queries that output the same kind of output and have the same grouping and order : select date_trunc('month', inserted_at)::date as date, count(id) from payment_logs where payment_logs.event_name = 'subscription_created' group by date order by date desc; select…
I have a table with the following columns: ClientID, Amount, etc. The problem is that some clients have two or more rows with Amount = 0, and I want to remove these rows. I've searched some information but only found…
As you can see below I have Name column. I want to split it by / and return the value in array. MyTable Id Name 1 John/Warner/Jacob 2 Kol If I write a query as Select Id, Name from MyTable…
I am working on a sensitive migration. The scenario is as follows: I have a new table that I need to populate with data There is an existing table, which contains a column (type = json), which contains an array…
so I got Questionnaire Data where the same Questions got asked multiple times, sadly they didnt think of giving them different question_ids, but at least i have the timestamps of when they were answered. Similar to this person_id question_id answer…
I have the next table that stores events: (simplified structure) ID User Action Timestamp 12 user1 END 2022-01-01 05:00 43 user1 START 2022-01-01 04:00 54 user1 END 2022-01-01 03:00 13 user1 START 2022-01-01 02:00 I need to join 2 events…
I am having some trouble figuring out on extracting a parameter (contactId) from a JSON list, and returning the extracted parameters in a list. Data Table Name: users contact ----------------------- 1 { "mainContact": { name: "Timmy Tom", contactId: "11111" phoneNumber:…