complex-sub- query完整测试数据

训练营与赛事 MiniOB
#1

select * from csq_1 where feat1 > (select min(csq_2.feat2) from csq_2 where csq_2.id in (select csq_3.id from csq_3 where csq_3.col3 <> (select csq_4.col4 from csq_4 where csq_4.id <> csq_1.id)));

  • FAILURE
    – below are some requests executed before(partial) –
    – init data
    CREATE TABLE csq_1(id int, col1 int, feat1 float);
    CREATE TABLE csq_2(id int, col2 int, feat2 float);
    CREATE TABLE csq_3(id int, col3 int, feat3 float);
    CREATE TABLE csq_4(id int, col4 int, feat4 float);
    INSERT INTO csq_1 VALUES (13, 94, 59.87);
    …这道题一直过不去，想知道这个测试的完整数据是什么
#3

麻烦提供一下题目的完整信息

#4

我也是我也是

select * from csq_1 where (select min(csq_2.col2) from csq_2) <> (select min(csq_3.col3) from csq_3);
- 34 | 55 | 56.62
- 35 | 64 | 26.28
- 65 | 88 | 52.27
- 7 | 32 | 41.24
- 95 | 56 | 50.54
-- below are some requests executed before(partial) --
-- init data
CREATE TABLE csq_1(id int, col1 int, feat1 float);
CREATE TABLE csq_2(id int, col2 int, feat2 float);
CREATE TABLE csq_3(id int, col3 int, feat3 float);
CREATE TABLE csq_4(id int, col4 int, feat4 float);
INSERT INTO csq_1 VALUES (7, 32, 41.24);
...

本地测试的逻辑是对的