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?...

Conversion of datetime format...

Presto/Trino/Athena - Wrong subtraction of casted varchar to double...

Grouping data based on a value in Athena...

How to select top 75% of rows using SQL...

presto/trino - Get key of mapped element given a value...

How do I get rid of this Error:Column alias list has 1 entries but 't' has 4 columns availab...

HIVE (Athena) - Separate array of PKs into column with corresponding value from FK table...

Transform correlated subquery to be used with presto / athena...

Select a string within a string within ATHENA...

FIRST_VALUE in Athena or Spark...

Add Trino dataset to Apache Superset...

SQL most frequent values on multiple columns group by other column...

Discrepancy between two similar presto SQL queries...

How to transform data into daily snapshot given the two date columns?...