I have a table named sales in a MySQL database that looks like this: company manufactured shipped Mercedes Germany United States Mercedes Germany Germany Mercedes Germany United States Toyota Japan Canada Toyota Japan England Audi Germany United States Audi Germany…
I have a SQL query that sorts a table for a local restaurant into categories, but after that I would like to sort alphabetically by title. The end result should sort the categories, and then the content is sorted alphabetically…
I have this query: select qt.id as id, ev.id as event_id, res.allocation_date as date from quota qt left join result res on qt.id=res.quota_fk and (res.allocation_date=(select max(res2.allocation_date) from result res2 where res2.quota_fk=qt.id)) left join event ev on qt.id=ev.quota_fk this query correctly…
sum( (record_id is NULL AND joined.table_id is NULL)::int ) I know the sum returns the sum of the column entries, but what will this expression (... and...) return, can it be compared with this expression (.. + ..), and what…
I have two tables: TableA Id Status User 1 15 111 2 15 111 3 15 111 And TableB which contains history of status changes from previous table: Id IdA Status Date 1 1 10 2023-01-18 2 1 30 2022-12-18…
I have the 2 following table : Source table with 2 columns (large number of records) : columnA columnB abcdez defghp azerty ghjklm ... ... Mapping table with source value and new value. All columnA and columnB values in the…
I've got a problem with a MySQL query. Suppose we have two tables: cars: id brand owner_id 1 toyota 24 2 ford 56 ... ... ... car_debts: id value car_id(fk) fl_unique(boolean) 24 50.0 1 0 25 40.0 1 0 26…
I have a ledger-like table in a postgresql DB that tracks events for film comparisons on a site where users can add/remove film comparisons. Each event is recorded as a timestamped row in the event database. Rows are never removed:…
Can't come up with easy solution how to union tables with same columns but from second table add only rows which are present in first table. t1: id A B C 1 xx r g 2 cc r g 5…
When running this query: SELECT id,col1,col2 FROM app_data.content_cards I get a table like this: +----+-------------------------------+--------+ | id | col1 | col2 | +----+-------------------------------+--------+ | 90 | {'one', 'two', 'three'} | {1,2,3}| +----+-------------------------------+--------+ | 91 | {'abc', 'def'} | {1,2} |…