In Presto SQL, for string column, how to remove text starting from a pattern in each string?...

Getting the max date per each Key per user...

PrestoDB -- Select rows where varchar column is in array query...

splitting start and end date to start_date / first day of month and end_date / last day of month...

How to extract value from a nested JSON object key with dots...

Looking to get a single observation output...

AWS Athena timestamp with offset...

Aggregations of transactions between two timestamps by an ID in SQL...

Group multiple rows values into a single row...

Temporal clustering in SQL...

how to drop duplicate rows based on multiple column values in Amazon Athena?...

Adding hours to dates in Presto...

athena (presto) windowing function...

Pivot in Presto SQL if you don't know the column names in advance...

Avoiding duplicates when joining tables...

Convert String column to JSON in AWS Athena...

Athena presto query of map type columns with dynamic key names...

Need to convert string value in Date Format in Athena...

How to calculate quartiles using schema and tables in Amazon Athena?...

Retain latest record by differentiate "actual NULL in data" vs "NULL due to field not...

Using columns from query in subquery in Athena...

Athena query returns "INVALID_TABLE_PROPERTY" for daily partition projection preview table...

SQL compare multiple column across two tables and output new compare result columns...

How to filter out certain keys in a map in Trino/Presto?...

Select random rows such that combination of a subgroup of columns is unique...

Aggregate columns in Athena...

Trino: Create a dynamic list of dates to fill values...

How do I add leading zero to a 7 digit date using When clause in SQL...

Select group by values depending on conditions...

How do I do a selection from table and a mapping using one of the column from the table as key?...