I have a table with the following structure: +------+--------------+--------------+ | SHOP | BUY_PROFIT | SELL_PROFIT | +------+--------------+--------------+ | A | 10 | 15 | +------+--------------+--------------+ I need to write select statement to make it look like this: +------+------+--------+ | SHOP…
I want to run a query towards PostgreSQL where any attribute in a JSON body matching a list of attribute names should equal a given value. The input: names: ["foo", "bar"], value: 'hello' should render a query such as SELECT…
Table "skus": plant_species_ids 1,2,3,2,3,1 Table "plant_species" id name 1 Plant 1 2 Plant 2 3 Plant 3 The relevant part of my MySQL code: ... GROUP_CONCAT(plant_species.name SEPARATOR ', ') as plant_species_names ... LEFT JOIN plant_species ON FIND_IN_SET(plant_species.id, skus.plant_species_ids) > 0…
The table is like: country fruit size Japan Apple Big Japan Apple Small Japan Orange Big Singapore Banana Small The expect output is like: country type total Japan 2 3 Singapore 1 1 I managed to run the counts separately.…
I have a database of a number of purchased plans with a value of minutes_left from which I want to subtract 1 number every minute. Now I am using this code using cron job: $sql = "SELECT * FROM pls";…
I have the following sample data with 3 columns, i.e., account_id, interval_start, interval_end. And I want to create a reactivated column with the given output in the following table. For each account_id, reactivated column should start with a 0 value…
I am writing a PostgreSQL trigger function that will allow me to do an ETL transformation on a data. I have a table with fields (id, price, EFF_FROM, EFF_TO), and if I only insert (id, price, EFF_FROM), EFF_TO needs to…
In a PostgreSQL 14 database I have a transactions table currently containing around 400 million elements and the following query on it: SELECT "transactions"."id" FROM "transactions" WHERE ("wallet_id" = $1) ORDER BY "transactions"."id" DESC LIMIT 10 This works fine and…
I am making a web store in ASP.NET with a SQL Server database. I'm currently working on a "edit users" part of control panel. I have list of all users and "edit" and "delete" buttons for each row of a…
I have 2 tables, which represent one to many relationship CREATE TABLE a( id int, a_text varchar(255) ); And CREATE TABLE b( a_id int, b_text varchar(255) ); Where column b_text contains enum values. Table A: Id a_text 1 'text 1'…