yql/essentials/tests/sql/suites/blocks/interval_div.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

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;