Step 1: Select rows where 'broadcast_date' is not equal to the maximum value of 'broadcast_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 'ratings' is greater than the maximum value of 'ratings'.
| 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% |
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: TRUE