I have on the datebase a table containing: created_at order_id customer_id I want to calculate the cumulative distinct number of customers per day. I wrote this query SELECT created_at::date, COUNT(DISTINCT customer_id) OVER (ORDER BY created_at::date) as cumulative_users FROM orders GROUP…
I've been building a laravel application, then xampp gave so many issues so I deleted it with the databases. Then created new empty database and tried to migrate, but it giving me this error: SQLSTATE[42S02]: Base table or view not…
The below query works well, it returns all the receipts which are composed of ingredients which can be found at home. The ingredients which are at home are: yiest, oil, flour, salt, water: SELECT * FROM receipts WHERE true =…
I have this table: create table TableName5 ( col1 varchar(200), col2 varchar(200), col3 varchar(200) generated always as ('col1' + 'col2') stored ); The col3 is supposed to be a computed column - the value in col1 plus the value in…
I need to parse data from Kafka in ClickHouse using Kafka Engine, as example, I have created a table, in https://fiddle.clickhouse.com/0e89bec6-4e76-410a-9fc4-cf58ace5f34f, CREATE TABLE json(name String, data Array(Map(String, String)) ) ENGINE = Memory; INSERT INTO JSON FORMAT JSONEachRow {"name": "asd", "data":[{"id":"1",…
I have two branches where I am using the exactly same PostgreSQL query but the group by clause becomes invalid for some reason. I have changed the primary key from id to composite (tenant_id, id). The old documents table Documents…
I am using this query to create an HTML table and send it by email. Is there any way to merge the cells for the Group ID and Total Transaction Sum columns only if they have the same value to…
I have a table called uk that contains a field called EvName. EvName is mediumtext format and contains entries with the following syntax: Rochdale 1st Jan - 12:20 2 hours 30 min I want to extract the time from EvName…
My goal is to get a result where it will output all exercise entries, with a single related video, then a concatenated string of all associated tags (where tags is one table and tag_linkage is how the tags relate to…
I have a User table I want to view each User by navigating /users/{slug}. e.g. for a User named John Doe the route would look like this /users/john-doe. Currently I am using the id to view a User (/users/1). To…