Plan-of-SQLs (Ours)


Statement: arienai kisu was broadcasted 14 days after the title with the earliest broadcast date

Ground-truth: FALSE

Input Table: tsuki no koibito

Step 1: Select rows where 'broadcast_date' is the earliest date.
unnamed__0 episode_title romanized_title translation_of_title broadcast_date ratings
ep 1 おまえが欲しい omae ga hosii i want you 2010-05-10 22.4%
ep 2 ありえないキス arienai kisu the unthinkable kiss 2010-05-17 19.2%
ep 3 復讐のプロポーズ fukusyū no puropōzu the proposal out of revenge 2010-05-24 15.6%
ep 4 こんなに好きだったんだ… konna ni suki dattanda… that 's how much i liked you 2010-05-31 15.5%
ep 5 好きと言えたらいいのに suki to ietara iinoni if only i could say , i like you 2010-06-07 17.4%
ep 6 最終章序幕・別れ saishūshōjomakuwakare a prologue of final chapter , farewell 2010-06-14 13.4%

Step 2: Select rows where 'episode_title' is 'arienai kisu'.
unnamed__0 episode_title romanized_title translation_of_title broadcast_date ratings
ep 1 おまえが欲しい omae ga hosii i want you 2010-05-10 22.4%

Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
unnamed__0 episode_title romanized_title translation_of_title broadcast_date ratings

Final output table:
verification_result
FALSE

Prediction: FALSE

Ground-truth: FALSE