I have the following table called worker_log: log_date total_workers store 2021-01-01 2 Ralphs 2021-02-01 0 Ralphs 2021-03-01 3 Ralphs 2021-01-01 3 Benny's 2021-02-01 0 Benny's 2021-03-01 1 Benny's For Ralphs, from 1/1/21 to 1/31/21, there were 2 total workers. From…
I am trying to solve an issue where I need to find the previous,current and next record where the query matches certain condition. In the example image below I am interested in only records where pattern_id=23587462 (can be multiple), and…
This my dataset and i want to find No. of gender name|gender| ----+------+ AA |Male | BB |Male | CC |Male | DD |Female| EE |Female| sql query : select gender,count(*) from schoolofit.user_request_1 group by gender result: gender|count| ------+-----+ Female|…
Here I have two nodes with the property 'name' that contains the first name and last name of a person. I create the vertices as: SELECT * FROM cypher('graph', $$ CREATE (n:Person {name : "Michael Stone", age : 20}), (m:…
Wondering if it is possible to keep just one record from duplicates. In this scenario, the ID is also duplicate. I know the best way is that ID is unique, but in this scenario is not. Then, I have three…
I want to calculate the time difference between two datetime. Saturday and sunday need to be excluded from the calculation. For exemple difference between 2023-01-10 15:12:24 and 2023-01-01 10:34:36 is 6 days 4 hours 37 minutes 48 seconds according to…
ALTER TABLE rejected_events.rejected_events ADD COLUMN tenant_id smallint NOT NULL DEFAULT 0; ALTER TABLE rejected_events.rejected_events ALTER COLUMN tenant_id DROP DEFAULT; In my product, tenant_id is set to 0 and then removed in next command as well. I wonder what would be…
I am looking for a way that is not too hacky to hash all ids before returning to user, is there a way to do so? I've searched all over docs and couldn't find anything that handles all scenarios. I…
We have a birthday column in the format DD.MM.YYYY (for example 25.04.1990) of string type. How can we find out the employee's age at the time of the query? I do not know how to change to date type and…
For example use Test table with only positive id value. Query select 1 from public.Test where id = 0 return empty result. But when I use this query: select case when exists(select 1 from public.Test where id = 0) then…