Following up on from my previous question: Get count of each email type from multiple tables I had to get clarification... So I do indeed need to have multiple tables. I then need to get a count of all the…
I have 15+ tables with emails. I need to count how many emails exist for each internet service provider, like GMAIL, VMG, MSFT, or Other. Using the below query, I can get a count of the ISPs for one table:…
I have two dates and I need to check that these two dates are within the same month of the same year. I have the following solution select to_char(:date1::date, 'yyyymm')::int2 = to_char(:date2::date, 'yyyymm')::int2 who has a better solution?
This might be a bit elaborate so please bear with me. I'm looking to create a new column free_duration in a table that currently looks like this, when grouped by country and product in ASCENDING order of month- month country…
I'm able to create the table using CTE with select statement like below but it's not behaving like I want. with sorting(item_code, index) as ( select (10001, 1), (10002, 2) ) select * from sorting Table result : item_code|index |…
I have two SQL queries like this for postgresql: The first query is fetching subscriptions that were never synced or that were updated recently and synced a long time ago: SELECT * FROM subscriptions WHERE (last_sync_at IS NULL OR last_sync_at…
I am trying to replace the value of one of the columns in the SELECT result to 0. Normally I can do: SELECT 0 AS column_to_set, other_col_1, other_col_2, ... FROM tbl However, there are lots of "other_cols" in the source…
I have a query that performs a count operation on a table with a specific condition. I expected that using an index would be enough to speed up the query, but the output from EXPLAIN ANALYZE indicates a full table…
I am using AWS Redshift. I have a table that looks like this: Id key value1 value2 value3 1 xxx A NULL NULL 1 xxx NULL B NULL 2 uuu NULL NULL C If the id is repeating, the entire…
So I'm solving a question of a project, and I need to calculate the Compound Annual Growth Rate (CAGR), together with the total sales of the top 5 EV makers from fiscal year 2022 to 2024. I found out the…