I need to create a Materialized view to loop all worklist tables from pg_tables. First I create a query and after tried to create a for loop. This my first code without the for loop. SELECT count(visit_num) AS total_claim_count, count(user_id)…
So far, I've come up with ORDER BY SUBSTRING(COLUMN FROM '[A-Z]+'), COALESCE(SUBSTRING(COLUMN FROM '(?<=-)[0-9]+')::INTEGER, 0), SUBSTRING(COLUMN FROM '(?<=()[0-9]+')::BIGINT Outcome Desired Outcome AC-1 AC-1 AC-2 (1) AC-2 AC-2 (2) AC-2 (1) AC-2 AC-2 (2) AC-3 (1) AC-3 (1) AC-3 (2) AC-3…
I'm working on MySQL workbench and I would like to find the top-selling products by types of buyers. First I categorized customers based on their buying activity. If a person made a purchase only on 1/1, it's a first-time buyer.…
I am trying to get last row with query to MySQL WordPress, The query is How much Post-Title with the title Germany each month, How can I reverse the result? Query: SELECT COUNT( p.id ) post_count, DATE_FORMAT( post_date, '%Y-%m' )…
Some context, I am using postgres and I have a table that has items defined something like this: CREATE TYPE EventType AS ENUM ('published', 'unpublished'); CREATE TABLE items ( id integer NOT NULL, name varchar(40) NOT NULL, event EventType NOT…
So I have a table where when executed the table loops through the data and will insert the row of values into the DB. At the moment I am using a basic insert statement (I know about SQL injection is…
Is there a way in Postgres to fetch a list of rows having specific IDs from a table, using one query without any subqueries. Table id value --------- 0 | 12 2 | 345 3 | Alan 4 | 0.345…
I have a large table called uk that includes fields called CurrTime and EvName. Using the following query (extract below) I create a new field called StartTime that extracts the time from EvName (which is a MEDIUMTEXT field). I want…
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…