SQLize Online / PHPize Online  /  SQLtest Online

with transaction as ( select 1 id, to_date('23-05-2022', 'dd-mm-yyyy') transaction_date, 33 client_id, 'EURO' currency, 259 amount from dual union all select 2 id, to_date('24-05-2022', 'dd-mm-yyyy') transaction_date, 34 client_id, 'USD' currency, 300 amount from dual union all select 3 id, to_date('25-05-2022', 'dd-mm-yyyy') transaction_date, 34 client_id, 'RUR' currency, 5000 amount from dual), currency as ( select 1 id, to_date('23-05-2022', 'dd-mm-yyyy') currency_date, 'EURO' currency, 69.0 VALUE from dual union all select 2 id, to_date('23-05-2022', 'dd-mm-yyyy') currency_date, 'USD' currency, 60 VALUE from dual union all select 3 id, to_date('24-05-2022', 'dd-mm-yyyy') currency_date, 'EURO' currency, 70 VALUE from dual union all select 4 id, to_date('24-05-2022', 'dd-mm-yyyy') currency_date, 'USD' currency, 59.5 VALUE from dual) select count(distinct transaction_date) from transaction /* select transaction_date+level-1 from transaction start with transaction_date=to_date('23-05-2022', 'dd-mm-yyyy') --(select min(transaction_date) from transaction) connect by level < (select count(distinct transaction_date) from transaction) */