## Summary **No review yet** ## Minimized query ```sql .import employee.db main PRAGMA table_xinfo(users); CREATE TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',(unistr_quote(5.0) * 1)), ('a','c',5.0), ('b','d',-8.25); SELECT a,b,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; SELECT * FROM T AS a RIGHT JOIN T AS b ON a.rowid = b.rowid; SELECT * FROM T; SELECT * FROM T AS a RIGHT JOIN T AS b ON a.rowid = b.rowid; SELECT * FROM T; WITH cte AS (SELECT a, COUNT(*) AS cnt FROM T GROUP BY a) SELECT * FROM cte WHERE cnt > 1; SELECT COUNT(c) FROM T; INSERT INTO T DEFAULT VALUES; ANALYZE; CREATE UNIQUE INDEX IF NOT EXISTS idx_T_5862 ON T(b); VACUUM; ``` ## Actual output ```sql 0 ``` ## Expectation ```sql ``` ## Flag ``` ```