mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 20:20:20 +00:00
14 lines
404 B
Plaintext
14 lines
404 B
Plaintext
|
|
CREATE TABLE t41(a INTEGER PRIMARY KEY, b INTEGER);
|
|
CREATE TABLE t42(d INTEGER PRIMARY KEY, e INTEGER);
|
|
CREATE TABLE t43(f INTEGER PRIMARY KEY, g INTEGER);
|
|
EXPLAIN QUERY PLAN
|
|
SELECT *
|
|
FROM t41
|
|
LEFT JOIN (SELECT count(*) AS cnt, x1.d
|
|
FROM (t42 INNER JOIN t43 ON d=g) AS x1
|
|
WHERE x1.d>5
|
|
GROUP BY x1.d) AS x2
|
|
ON t41.b=x2.d;
|
|
|