Mysql – How to calculate the remaining amount per row?
I have a wallet table like this: // wallet +----+----------+--------+ | id | user_id | amount | +----+----------+--------+ | 1 | 5 | 1000 | | 2 | 5 | -200 | | 3 | 5 | -100 | |…
Mysql – SQL matching rows as pairs from the same table when they have the same attribute
I have three tables in my database, one for clients, one for products and one for orders, containing both the primary keys of products and clients as a foreign key. I am using SQL and MySQL A query I'm struggling…
Mysql – Sequelize CLI migration error Cannot read properties of undefined (reading 'detail')
I'm running npx sequelize-cli db:migrate to create the table in the database and returns the following message: Sequelize CLI [Node: 18.9.1, CLI: 6.5.1, ORM: 6.20.1] ERROR: Cannot find "/src/db/migrations/config/config.json". Have you run "sequelize init"? ERROR: Cannot read properties of undefined…
Mysql – How can I count data from a column being added in the same query?
I have a query setup for data verification that will join a few tables and auto-convert currencies from non-USD to USD. SELECT c.Id, c.Currency , cr.CPDealId, cr.UnderwriterId, cr.PlacedDate, cr.Fee, cr.FeeDue, cr.AllocatedFeeDue , f.Rate , (CASE WHEN c.Currency <> 'USD' THEN…
Mysql – How to Select latest record for a customer from a table with column value from the first row
I have scenario like below Sign up promo code The sign up promo code, if applicable, is what the member used to create their membership. Our system currently creates a new line for a member each time they make a…
Mysql – Most frequently occurring value in sql
I have created a sample table here: https://dbfiddle.uk/wUvTIsyN I am trying to query the most frequently occurring value with group by. Here's my attempt: select pid, propName, Address, City, Response, count(Response) as cr from Prop group by pid, propName, Address,…
AWS Redshift SQL equivalent of Tableau – Amazon web services
I have this code in tableau which I need to convert to Redshift SQL ( zn( sum([Market_Price]) )- zn( sum( if ISNULL([Market_Price]) then null else [Initial_Price] end ) ))/ zn(sum([Market_Price])) I have tried but not getting the same results. Do…
Postgresql – Total distance for points in same table sql
I do have the following three tables within postgres ShipmentTrip id,shipment_id, type,status,lat,long 1, 1, pickup, whatever, 25, 75 2, 1, dropoff, whatever, 27, 76 3, 2, pickup, whatever, 25, 75 4, 2, dropoff, whatever, 27, 76 Shipment id,...,driver_id Driver id…
SQL – Presto: Create a new table that counts values without duplicates having issues (AWS Athena) – Amazon web services
I have a response_data_v0 that contains several duplicates of the UUID values that I want to ignore, keeping just the value that contains the oldest date (In other words, I only want the row with the first appearance of that…
Postgresql – Getting error in postgres query No operator matches the given name and argument types
Reason why code is causing error when groupHds is null? I'm getting this error, groupHds is list of string and ddi.group_hd is string column. Error: Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bytea Hint: No operator…