I have 3 tables: products, product_options and product_option_choices. Products can have multiple options, options can have multiple choices. Choices can adjust the main product price (choice_price_adjust field). What I'm trying to do is fetch the products and have a field…
I have a table partitioned by date-type column ds, with many fields. Not all columns change every day, therefore most rows are just duplicates of the previous rows. I want to create an SCD2 table from the existing one (partitioned)…
Please refer to this db fiddle (SQL also pasted below): https://www.db-fiddle.com/f/bJ5FfufvP9GHPYtBhkywdP/5 I would like to show rows from the "mpr_metrics" table that have NO associated reviews. But here's the catch: if there is a metric with an associated review, AND…
Context To describe the situation I find myself in currently, let's take the 3 tables relevant to this: CREATE TABLE steam_user ( id SERIAL PRIMARY KEY, username TEXT NOT NULL, steam_id TEXT NOT NULL, profile_url TEXT NOT NULL, avatar_url TEXT…
I'm looking for assistance with writing a PostgreSQL query in Apache Superset. I have metered consumption data, where the meters have unique IDs. Normally, a meter is read at the start of every hour, and the difference is calculated in…
I am doing this HackerRank SQL question and cannot understand why this OFFSET does not work.This is for MySQL syntax: SELECT ROUND(LAT_N, 4) FROM STATION ORDER BY LAT_N LIMIT 1 OFFSET (SELECT FLOOR(COUNT(*) / 2) FROM STATION); But if I…
I have a VIEW that looks like this: | email | list | sent_last_30_days | -------------------------------------- | email1 | list1 | 1 | | email2 | list1 | 0 | | email1 | list2 | 1 | | email3 |…
I have a PostgreSQL table: create table test(type_id, m_id)as values (1, 123) ,(2, 456) ,(3, 123) ,(4, 123) ,(2, 456) ,(1, 789) ; Basically, one m_id could have multiple rows in this table associated with different type_ids. How can I…
I want to generate JSON from two usual clickhouse columns and value of one such column has backslash in its containment. First I create table CREATE TABLE app_events.al_test (col1 String,col2 String) ENGINE = MergeTree ORDER BY col1; Then I insert…
I have a table in a PostgresSQL where I am doing a migration from other database. I have a id field which is defined by Auto increment using sequence feature in postgres. Whenever I truncate the table and insert the…