I'm working with a Postgres table named orders that looks like this: user_id product order_date 1 pants 7/1/2022 2 shirt 6/1/2022 1 socks 3/17/2023 3 pants 2/17/2023 4 shirt 3/13/2023 2 pants 8/15/2022 1 hat 4/15/2022 5 hat 3/14/2023 2…
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 need to compose a MySQL query, which will count the number of email occurrences per each country I have following mysql table (shop_orders) order_id email country 1 [email protected] _it 2 [email protected] _hu 3 [email protected] _de 4 [email protected] _pl 5…
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…
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…
I have 2 models : Application and Contact. I use a polymorphic relation "contactable". A contact can be referenced to many applications (or other modeles), and can be referenced many times to the same application. In this case, the relations…
I'm trying to generate the following output: type totals CostA 1500 CostB 200 CostC 300 From a table with this structure: CostA CostB CostC name date -- more columns ... The table has more columns but I want the sum…
I have a table with customer ids and product names as columns and I want to create a matrix with the product names so that I can see how many customer buy the same product combinations. I was not able…
Here is my data id|col_name|value| --+--------+-----+ 1|col1 |ABC | 2|col2 |DEF | 2|col2 |FGH | 2|col2 |IJK | 3|col3 |MNO | 3|col3 |PQR | 3|col3 |STU | 3|col3 |XYZ | And the expected output is id Col1 Col2 col3 1…
I have this database schema: drop table if exists demo_contact cascade; create table demo_contact (id serial primary key); insert into demo_contact values (1); insert into demo_contact values (2); insert into demo_contact values (3); drop table if exists demo_contact_custom_field cascade; create…