Query Dashboard
four analytical queries · live dataset
stockroom@wms:~/sql$
booting engine…
Required analytics · queries 01–04
Extended analytics · derived queries
Product master
Movement ledger
Action queue Q1 + rules
Reorder plan Q5
Alert rule set
SQL console
⌘/Ctrl + ⏎ to run
1
Result set
no result yet — press ⌘/Ctrl + ⏎
Query library
Schema
SUPPORTED GRAMMAR
SELECT · DISTINCT · expressions · aliases · FROM · INNER/LEFT JOIN … ON · WHERE · GROUP BY · HAVING · ORDER BY (alias or position) · LIMIT · SUM/COUNT/AVG/MIN/MAX/GROUP_CONCAT · NOW() · DATE() · DATE_SUB/DATE_ADD(…, INTERVAL n DAY) · ROUND · ABS · COALESCE · IF · LIKE · IN · BETWEEN · IS NULL · CASE.
SELECT · DISTINCT · expressions · aliases · FROM · INNER/LEFT JOIN … ON · WHERE · GROUP BY · HAVING · ORDER BY (alias or position) · LIMIT · SUM/COUNT/AVG/MIN/MAX/GROUP_CONCAT · NOW() · DATE() · DATE_SUB/DATE_ADD(…, INTERVAL n DAY) · ROUND · ABS · COALESCE · IF · LIKE · IN · BETWEEN · IS NULL · CASE.