I'm building a language learning platform, here are some tables: create table users ( id bigserial primary key, ... ) create table users_languages ( id bigserial primary key, user_id bigint not null constraint users_languages_user_id_foreign references users, level varchar(255) not null,…
I have a mysql table with the following structure: Assign Pri Sec Ter Qua 21 Tom Mark Sally Tammy 60 Sally Ace Tom Mark 170 Mark Sally Ace Tammy 220 Ace Tammy Tom Sally 17 Tammy Sally Mark Ace 439…
I have values like below in dealer_price(type string) field: | dealer_price | | -------- | | 1000.00| | 5000.00| | Contact for pricing| | 10000.00| I have queries something like below to perform arithmetic operation: select (dealer_price + 10) AS…
I've a Postgres table like this where a order count for each tenant is inserted when it changes. datetime tenant_id orders 2023-09-15 22:00 tenant3 2 2023-09-16 01:00 tenant1 2 2023-09-16 02:00 tenant1 3 2023-09-16 02:00 tenant2 5 2023-09-16 03:00 tenant1…
i'm trying to create a query that allows me to get 2 counts from selects. I have a table (name "warehouses") with the following design and data: nation city italy roma germany berlin italy roma france paris italy torino italy…
I'm using PostgreSQL with the following (simplified) DB design: I have a table Auction, each auction can be handled from a Tribunal or a Court of Appeal. So that I have the table Court of Appeal (primary key = [id]…
I've been trying to make a query more efficient by bringing together counts from multiple tables. I have a schema similar to this: create table "impressions" ( id serial primary key, ip inet, ad_id integer references ad(id), user uuid references…
update loan l inner join ( select LoanId, sum(Amount) as Amount from loanpayment where LoanId = pLoanId ) as lp on l.Id = lp.LoanId set l.CurBalance = OriginalAmount + TermMonths *(OriginalAmount * MonthlyRate/100) - coalesce(lp.Amount,0) where l.Id = pLoanId ;…
I built a woocommerce sql query to list all products with their important values. Here my query: SELECT p.ID, p.post_type as Art, p.post_title AS Produkt, p.post_excerpt AS Beschreibung, t.name AS Produzent, MAX(CASE WHEN pm1.meta_key = 'faktor' then pm1.meta_value ELSE NULL…
I have a table A, where data is a json column, and timestamp is a timestamp with timezone column: timestamp data 2023-08-29 13:00:00-04 { "a_123":{ "temp":85, "uv":5, "rain":0 }, "b_123":{ "temp":85, "uv":5, "rain":0 } } 2023-08-29 14:00:00-04 { "a_123":{ "temp":70,…