mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-05-22 15:58:18 +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;
|
||
|
|
|