SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
with qt as (select 1 as period_begin, 3 as period_end, 1 as qtr union all select 4 as period_begin, 6 as period_end, 2 as qtr union all select 7 as period_begin, 9 as period_end, 3 as qtr), dt as (select 1 as dte union all select 2 as dte union all select 1 as dte union all select 2 as dte union all select 6 as dte union all select 7 as dte union all select 4 as dte union all select 5 as dte union all select 8 as dte) select count(*) dtes, qt.qtr from qt, dt where dt.dte between qt.period_begin and qt.period_end group by qt.qtr;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear