Posts by Camila Lira Alves • 11 points

• 1

  votes

  1

  answer

  65

  views

  Q: Count without returning 0 in Presto

  My query is this: with dates as ( SELECT CAST(date_column AS DATE) DAY FROM ( VALUES ( SEQUENCE(cast('2019-10-29' AS date), current_date, INTERVAL '1' DAY) ) ) AS t1(date_array) CROSS JOIN…

  sql

  asked 4 years, 9 months ago Camila Lira Alves 11