Aid to calculation

First, one could use the very structure of tables as an aid to calculation. Columns could be totalled; products could be found across rows;

→ author: Francis Hunger, published on: 2017-Mar-08

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

VERSION

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

ID

FROM

WHERE

IN

AND

IN

SELECT

FROM

WHERE

AND

AND

ORDER

BY

DESC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

SELECT

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

ASC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT