ydb/yt/yql/tests/sql/suites/blocks/interval_mul.sql

USE plato;

SELECT
    a.ni * b.i8,
    a.wi * b.i8,
    a.ni * b.u8,
    a.wi * b.u8,
    a.ni * b.i16,
    a.wi * b.i16,
    a.ni * b.u16,
    a.wi * b.u16,
    a.ni * b.i32,
    a.wi * b.i32,
    a.ni * b.u32,
    a.wi * b.u32,
    a.ni * b.i64,
    a.wi * b.i64,
    a.ni * b.u64,
    a.wi * b.u64,
FROM Dates as a CROSS JOIN Dates as b;

SELECT
    b.i8 * a.ni,
    b.i8 * a.wi,
    b.u8 * a.ni,
    b.u8 * a.wi,
    b.i16 * a.ni,
    b.i16 * a.wi,
    b.u16 * a.ni,
    b.u16 * a.wi,
    b.i32 * a.ni,
    b.i32 * a.wi,
    b.u32 * a.ni,
    b.u32 * a.wi,
    b.i64 * a.ni,
    b.i64 * a.wi,
    b.u64 * a.ni,
    b.u64 * a.wi,
FROM Dates as a CROSS JOIN Dates as b;