I have a table of changes like this CREATE TABLE IF NOT EXISTS changes ( entity_id TEXT NOT NULL, column_id TEXT NOT NULL, value JSONB NOT NULL, updated_at TIMESTAMP NOT NULL ); INSERT INTO changes VALUES ('1', 'height', to_jsonb(140), '01-01-2021…
I'm trying to join data together, my goal is to have list of sellers, and see next to each seller, the median time it took him to sell his items. The following query works as expected on a single seller…
I have a MySQL transfers table with the following structure: CREATE TABLE `transfers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `id_account_destination` bigint(20) unsigned NOT NULL, `id_account_origin` bigint(20) unsigned NOT NULL, `amount` decimal(10, 2) signed NOT NULL DEFAULT 0, `created_at` datetime…
I have a notifications table which stores userID,isRead,type,message UserID is id of user. isRead stores 1/0 for read/unread. Type stores the kind of notification, "mention/follow/reply". message is message which the user will see. I need a group by query that…
Good morning, I need some help and would really appreciate it. I have a table that looks like the following: But I want it to look like this so its easier for the user to read: How do i change…
I wrote sql select array_agg(id) as ids from fff group by a_c_id, a_c_dttm, a_c_code having COUNT(*)>1 which returns results {5,9} {8,12,13} {6,10} {7,11} How to exclude max value in each row for getting this result? {5} {8,12} {6} {7} the…
Assume I have a table as follow: product date value A 1 2 A 2 0 A 3 3 A 4 0 B 1 1 B 2 0 C 1 1 C 2 2 C 3 4 I am trying…
Given the following table mileage, I should perform two sums for each vehicle_id: once summing all entries for miles and another - all entries for miles only where is_processed = false. mileage vehicle_id miles is_processed created_at 773 800 f 2023-04-17…
I have the following table (offer_properties) in MYSQL for an e-commerce website: +----------+-------------+---------+ | offer_id | pkey | pvalue | +----------+-------------+---------+ | 63 | shoesize | shoe_47 | | 63 | sport | walking | | 63 | color |…
I have a table like this CREATE TABLE fake_sales ( group_id INT NOT NULL, year SMALLINT CHECK(year > 0), amount DECIMAL(10, 2) NOT NULL, PRIMARY KEY(year, group_id) ); I want to compare the current year's sale with the last year's…