FREE AI-Enhanced Online PostgreSQL Compiler

Untitled*

You must execute the code again to save those values in the database.

create table invoice (c5633_485 integer, c5633_503 integer, c5633_505 integer);
create table t1704(c5633_14777 integer, c5633_14778 integer, c5633_2184 integer, c5633_2185 integer, c5633_2187 integer,c5633_2186 integer );
INSERT INTO invoice VALUES (1, 1, 1);
INSERT INTO invoice VALUES (2, 2, 2);
INSERT INTO invoice VALUES (3, 3, 3);
INSERT INTO t1704 values (1, 1, 1, 1, 1, 1);
INSERT INTO t1704 values (2, 2, 2, 2, 2, 2);

SELECT Sum(invoice.c5633_505 * (
  SELECT max(mainrate.c5633_14777 + mainrate.c5633_14778)
  FROM   t1704 AS mainrate
  WHERE  mainrate.c5633_2184 is not null
  AND    mainrate.c5633_2185 is not null
  AND    mainrate.c5633_2187 = invoice.c5633_503
  AND    mainrate.c5633_2186 = (
    SELECT max(cr.c5633_2186)
    FROM   t1704 AS cr
    WHERE  cr.c5633_2187 = mainrate.c5633_2187
    AND    cr.c5633_2184 =
    mainrate.c5633_2184
    AND    cr.c5633_2185 = mainrate.c5633_2185
    AND    cr.c5633_2186 <= invoice.c5633_485))) AS invamount,
    count(*)       AS invcount
    FROM    invoice
    WHERE  invoice.c5633_505 < 10 AND  invoice.c5633_505 > 0

invamount	invcount
10	3

CREATE TABLE
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1