I'm trying to join 2 tables and count the number of entries for unique variables in one of the columns. In this case I'm trying to join 2 tables - patients and trials (patients has a FK to trials) and…
This might be difficult to explain. But Im trying to write a redshift sql query where I have want the count of organizations that fall into different market buckets. There are 50 markets. For example company x can be only…
I am trying to create a cumulative count for unique customers only by the month they purchased. The example Table is: customer_email cohortMonth [email protected] 10/2019 [email protected] 10/2019 [email protected] 10/2019 [email protected] 11/2019 [email protected] 11/2019 [email protected] 12/2019 The output I am looking…
I have a table called Sets for LEGO: set_number (Primary Key) set_name other_fields 123 Firetruck abc 234 Star Wars abc I have another table called Parts for LEGO: part_number (Primary Key) name set_number (references set_number from Sets) 1 Truck Roof…
I have created some schemas (dsfv, dsfn, etc.) and insert some tables inside each schema, including the following tables : poste_hta_bt (parent table with attribute "code_pt" as unique key); transfo_hta_bt (having also "code_pt" attribute as foreign key that referenced poste_hta_bt).…
Let's say I have the following PostgreSQL database schema: Group id: int Task: id: int created_at: datetime group: FK Group I have the following Materialized View to calculate the number of tasks and the most recent Task.created_at value per group:…
i just started my journey with SQL, and made some tables of Cyclists, and Cycling Teams. Cyclist's table contains columns: ID, Name, Team (which is foreign key of TEAMS ID) Team's table contains columns: ID, Name, Number of Cyclists I…
I have a very similar problem to this one: Count unique occurrences per each distinct variable in MySQL but with a twist. I'm working with a select statement that shows results much like what the above-mentioned question does. If I…
I have the following situation: A user can have maximum number of partnerships. For example - 40.000 Question: In case user wants to add a new partnership, how it will be faster to check the current number of partnerships ?…
I got 3 tables | ID | Name | |:---- |:------:| | 1 | Brie | | 2 | Ray | | 3 | James | Table2 | ID | Q_id | Q_no | ans | |:---- |:------:| -----:|----:| |…