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