create table completion(
    ts timestamp time index,
    model string primary key,
    val double
);

Affected Rows: 0

insert into completion values
    (0, 'model-a', 10),
    (5000, 'model-b', 20),
    (10000, 'model-a', 30);

Affected Rows: 3

create table prompt(
    ts timestamp time index,
    model string primary key,
    val double
);

Affected Rows: 0

insert into prompt values
    (0, 'model-a', 100),
    (5000, 'model-b', 200),
    (10000, 'model-a', 300);

Affected Rows: 3

-- SQLNESS SORT_RESULT 3 1
tql eval(0, 10, '5s') sum(completion * 0.0015 / 1000) + sum(prompt / 1000 * 0.0015);

+---------------------+-----------------------------------------------------------------------------------------------------------+
| ts                  | completion.SUM(val * Float64(0.0015) / Float64(1000)) + prompt.SUM(val / Float64(1000) * Float64(0.0015)) |
+---------------------+-----------------------------------------------------------------------------------------------------------+
| 1970-01-01T00:00:00 | 0.000165                                                                                                  |
| 1970-01-01T00:00:05 | 0.000495                                                                                                  |
| 1970-01-01T00:00:10 | 0.000825                                                                                                  |
+---------------------+-----------------------------------------------------------------------------------------------------------+

-- SQLNESS SORT_RESULT 3 1
tql eval(0, 10, '5s') sum(completion * 0.0015 / 1000) + sum(prompt * 0.0015 / 1000);

+---------------------+-----------------------------------------------------------------------------------------------------------+
| ts                  | completion.SUM(val * Float64(0.0015) / Float64(1000)) + prompt.SUM(val * Float64(0.0015) / Float64(1000)) |
+---------------------+-----------------------------------------------------------------------------------------------------------+
| 1970-01-01T00:00:00 | 0.000165                                                                                                  |
| 1970-01-01T00:00:05 | 0.000495                                                                                                  |
| 1970-01-01T00:00:10 | 0.000825                                                                                                  |
+---------------------+-----------------------------------------------------------------------------------------------------------+

-- SQLNESS SORT_RESULT 3 1
tql eval(0, 10, '5s') sum(completion * 0.0015 / 1000) by (model) + sum(prompt * 0.0015 / 1000) by (model);

+---------+---------------------+-----------------------------------------------------------------------------------------------------------+
| model   | ts                  | completion.SUM(val * Float64(0.0015) / Float64(1000)) + prompt.SUM(val * Float64(0.0015) / Float64(1000)) |
+---------+---------------------+-----------------------------------------------------------------------------------------------------------+
| model-a | 1970-01-01T00:00:00 | 0.000165                                                                                                  |
| model-a | 1970-01-01T00:00:05 | 0.000165                                                                                                  |
| model-a | 1970-01-01T00:00:10 | 0.000495                                                                                                  |
| model-b | 1970-01-01T00:00:05 | 0.00033                                                                                                   |
| model-b | 1970-01-01T00:00:10 | 0.00033                                                                                                   |
+---------+---------------------+-----------------------------------------------------------------------------------------------------------+

-- SQLNESS SORT_RESULT 3 1
tql eval(0, 10, '5s') sum(completion / 1000) + max(completion / 1000);

+---------------------+---------------------------------------------------------------------------+
| ts                  | completion.SUM(val / Float64(1000)) + completion.MAX(val / Float64(1000)) |
+---------------------+---------------------------------------------------------------------------+
| 1970-01-01T00:00:00 | 0.02                                                                      |
| 1970-01-01T00:00:05 | 0.05                                                                      |
| 1970-01-01T00:00:10 | 0.08                                                                      |
+---------------------+---------------------------------------------------------------------------+

-- SQLNESS SORT_RESULT 3 1
tql eval(0, 10, '5s') sum(completion / 1000) + sum(completion / 1000);

+---------------------+---------------------------------------------------------------------------+
| ts                  | completion.SUM(val / Float64(1000)) + completion.SUM(val / Float64(1000)) |
+---------------------+---------------------------------------------------------------------------+
| 1970-01-01T00:00:00 | 0.02                                                                      |
| 1970-01-01T00:00:05 | 0.06                                                                      |
| 1970-01-01T00:00:10 | 0.1                                                                       |
+---------------------+---------------------------------------------------------------------------+

drop table completion;

Affected Rows: 0

drop table prompt;

Affected Rows: 0