Let's say I have a table in Postgres that stores a column of strings like this. animal cat/dog/bird dog/lion bird/dog dog/cat cat/bird What I want to do, is calculate how "correlated" any two animals are to each other in this…
I have the next Tree Structure : This structure is represented in the database with the next Table: --------------------------------Employees------------------------------------------- ------------------------------------------------------------------------------------- | Employee_name | Global_Team | Team | ------------------------------------------------------------------------------------- |name_of_head_of_engineering | - | Engineering | ------------------------------------------------------------------------------------- |name_1_T1 | Engineering | Team_1…
How can I convert this to normal query? WITH cte AS ( SELECT agentID, SUM(bonus > 0) OVER (PARTITION BY agentID ORDER BY `year` * 12 + `month` RANGE BETWEEN 2 PRECEDING AND CURRENT ROW) flag FROM test ) SELECT…
Background I'm running Postgres 11 on CentOS 7. I recently learned the basics of recursive CTEs in Postgres thanks to S-Man's answer to my recent question. The problem While working on a closely related issue (counting parts sold within bundles…
My goal To calculate the sum of components sold as part of their parent assemblies. I'm sure this must be a common use case, but I haven't yet found documentation that leads to the result I'm looking for. Background I'm…