I'm trying to update rows in a scores table based on the following logic: Get the feat_sum for ids that don't have a score. For each feat_sum that has a NULL score, get the row with the nearest feat_sum and…
I am trying to execute the below update query using GROUP_CONCAT but it is failing. Can anyone kindly help me in correcting it, moreover the statement must always start with the “update” keyword is the catch here as well. UPDATE…
I want to create a table. I'm having long and hard time about naming columns. If there are 3 columns having same characteristics. ex) tag_1, tag_2, tag_3 -> CREATE TABLE BOARD ( BOARD_ID bigint not null primary key, TAG_1 varchar(10)…
I have a dogs table that looks like this: create table dogs (name char(10), breed, char(20), age int); insert into dogs (name, breed, age) values ('A', 'Breed 1', 1); insert into dogs (name, breed, age) values ('B', 'Breed 2', 2);…
In Postgres, I set out to write a SQL statement that would return various fields from one table, along with a column containing an array of tag strings that come from another table. I've made quite good progress with this…
I'm new in programming and I've built projects on xampp. There I created the databases in SQL (MARIADB) in 2 separated files (DML and DDL). Now, learning Symfony I found that looks like I must use ORM to create the…
I am trying to design a database of customer details. Where customers can have up to two different phone numbers. When I run the Select * command to bring out the customers that match criteria, I get this: Name |…
The following procedure is run on a table with 20M records. It stopped at ~560000 and I don't know why. I'm still learning DB monitoring/troubleshooting. This is on Aurora Postgres Serverless v2 with 6 ACUs (12 GB mem). The content…
I have the first three fields of the following table. I want to compute the number of consecutive days an amount was higher than 0 ("days" field). key date amount days 1 2023-01-23 0 0 1 2023-01-22 10 2 1…
Is there a way to join 2 tables with one query to DB in a way when records from one table are put as an array value in a 'new' column in another table? (It's clear how to do it…