SELECT EXTRACT(MONTH FROM t.saledate) as month_num, EXTRACT(YEAR FROM t.saledate) as year_num, COUNT(DISTINCT t.saledate) as nb_distinct_dates FROM trnsact t GROUP BY month_num, year_num ORDER BY year ...
This is a DuckDB extension for connecting to and "attach":ing Teradata databases as if they were part of the DuckDB catalog. It allows you to manipulate tables, query data, and execute raw SQL ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results