File size: 7,275 Bytes
3bed294 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 |
<html><head>
<style>
body { font-family: Arial, sans-serif; margin: 20px; }
h1 { text-align: center; }
.cot-title { color: blue; }
.pos-title { color: green; }
h2 { color: black; text-align: left; }
h3 { color: black; text-align: left; }
h4 { color: darkslategray; }
table { width: 100%; border-collapse: collapse; margin: 20px 0; }
table, th, td { border: 1px solid #ddd; padding: 8px; }
th { background-color: #f2f2f2; }
tr:nth-child(even) { background-color: #f9f9f9; }
.highlight { background-color: #ffffcc; }
.true { color: green; }
.false { color: red; }
.highlighted-cell { background-color: yellow; cursor: pointer; }
.step-title { background-color: #f1f1f1; color: #444; padding: 10px; margin: 10px 0; font-size: 18px; border-left: 4px solid #888; }
.step { display: block; }
</style>
</head><body>
<hr>
<h3><span>Statement:</span> fukusyū no puropōzu had 2.2% higher ratings than the title with the most recent broadcast date</h3>
<h3>Input Table: tsuki no koibito</h3>
<div class="step">
<div class="step">
<div class="step-title">Step 1: Select rows where 'broadcast_date' is not equal to the maximum value of 'broadcast_date'.</div>
<div id="step-1" class="content">
<table>
<tr>
<td>unnamed__0</td>
<td>episode_title</td>
<td>romanized_title</td>
<td>translation_of_title</td>
<td>broadcast_date</td>
<td>ratings</td>
</tr>
<tr>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ep 1</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">おまえが欲しい</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">omae ga hosii</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">i want you</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2010-05-10</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">22.4%</span></td>
</tr>
<tr>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ep 2</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ありえないキス</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">arienai kisu</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">the unthinkable kiss</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2010-05-17</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">19.2%</span></td>
</tr>
<tr>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ep 3</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">復讐のプロポーズ</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">fukusyū no puropōzu</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">the proposal out of revenge</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2010-05-24</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">15.6%</span></td>
</tr>
<tr>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ep 4</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">こんなに好きだったんだ…</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">konna ni suki dattanda…</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">that 's how much i liked you</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2010-05-31</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">15.5%</span></td>
</tr>
<tr>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">ep 5</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">好きと言えたらいいのに</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">suki to ietara iinoni</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">if only i could say , i like you</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:#90EE90;">2010-06-07</span></td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">17.4%</span></td>
</tr>
<tr>
<td>ep 6</td>
<td>最終章序幕・別れ</td>
<td>saishūshōjomakuwakare</td>
<td>a prologue of final chapter , farewell</td>
<td><span class="highlighted-cell" title="Used in transformation" style="background-color:yellow;">2010-06-14</span></td>
<td>13.4%</td>
</tr>
</table>
</div>
<hr>
<div class="step">
<div class="step-title">Step 2: Select rows where 'ratings' is greater than the maximum value of 'ratings'.</div>
<div id="step-0" class="content">
<table>
<tr>
<td>unnamed__0</td>
<td>episode_title</td>
<td>romanized_title</td>
<td>translation_of_title</td>
<td>broadcast_date</td>
<td>ratings</td>
</tr>
<tr>
<td>ep 1</td>
<td>おまえが欲しい</td>
<td>omae ga hosii</td>
<td>i want you</td>
<td>2010-05-10</td>
<td>22.4%</td>
</tr>
<tr>
<td>ep 2</td>
<td>ありえないキス</td>
<td>arienai kisu</td>
<td>the unthinkable kiss</td>
<td>2010-05-17</td>
<td>19.2%</td>
</tr>
<tr>
<td>ep 3</td>
<td>復讐のプロポーズ</td>
<td>fukusyū no puropōzu</td>
<td>the proposal out of revenge</td>
<td>2010-05-24</td>
<td>15.6%</td>
</tr>
<tr>
<td>ep 4</td>
<td>こんなに好きだったんだ…</td>
<td>konna ni suki dattanda…</td>
<td>that 's how much i liked you</td>
<td>2010-05-31</td>
<td>15.5%</td>
</tr>
<tr>
<td>ep 5</td>
<td>好きと言えたらいいのに</td>
<td>suki to ietara iinoni</td>
<td>if only i could say , i like you</td>
<td>2010-06-07</td>
<td>17.4%</td>
</tr>
</table>
</div>
</div>
<hr>
<div class="step">
<div class="step-title">Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.</div>
<div id="step-1" class="content">
<table>
<tr>
<td>unnamed__0</td>
<td>episode_title</td>
<td>romanized_title</td>
<td>translation_of_title</td>
<td>broadcast_date</td>
<td>ratings</td>
</tr>
</table>
</div>
</div>
<hr>
<div class="step">
<div class="step-title">Final output table:</div>
<div id="step-2" class="content">
<table>
<tr>
<td>verification_result</td>
</tr>
<tr>
<td>FALSE</td>
</tr>
</table>
</div>
</div>
<hr>
<h3>Prediction:</span> FALSE</h3>
</body></html>
|