File size: 8,675 Bytes
8431e47 |
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 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 |
<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> antonio pompa - baldi italy was first in 1999 and 2000</h3>
<h3>Input Table: cleveland international piano competition</h3>
<div class="step">
<div class="step">
<div class="step-title">Step 1: Select rows where 'first' is 'antonio pompa - baldi italy'.</div>
<div class="content" id="step-1">
<table>
<tr>
<td>year</td>
<td>first</td>
<td>second</td>
<td>third</td>
<td>fourth</td>
</tr>
<tr>
<td>2013</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">stanislav khristenko russia</span></td>
<td>arseny tarasevich - nikolaev russia</td>
<td>françois dumont france</td>
<td>jiayan sun china</td>
</tr>
<tr>
<td>2011</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">alexander schimpf germany</span></td>
<td>alexei chernov russia</td>
<td>eric zuber usa</td>
<td>kyu yeon kim south korea</td>
</tr>
<tr>
<td>2009</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">martina filjak croatia</span></td>
<td>dmitri levkovich canada</td>
<td>william youn south korea</td>
<td>evgeny brakhman russia</td>
</tr>
<tr>
<td>2007</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">alexander ghindin russia</span></td>
<td>yaron kohlberg israel</td>
<td>alexandre moutouzkine russia</td>
<td>ran dank israel</td>
</tr>
<tr>
<td>2005</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">chu - fang huang china</span></td>
<td>sergey kuznetsov russia</td>
<td>stanislav khristenko russia</td>
<td>spencer myer usa</td>
</tr>
<tr>
<td>2003</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">kotaro fukuma japan</span></td>
<td>soyeon lee south korea</td>
<td>konstantin soukhovetski russia</td>
<td>andrius zlabys lithuania</td>
</tr>
<tr>
<td>2001</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">roberto plano italy</span></td>
<td>minsoo sohn south korea</td>
<td>özgür aydin turkey</td>
<td>gilles vonsattel switzerland</td>
</tr>
<tr>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">1999</span></td>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">antonio pompa - baldi italy</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">vassily primakov russia</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">shoko inoue japan</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">sean botkin usa</span></td>
</tr>
<tr>
<td>1997</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">per tengstrand sweden</span></td>
<td>gulnora alimova uzbekistan</td>
<td>ning an china</td>
<td>dror biran israel</td>
</tr>
<tr>
<td>1995</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">margarita shevchenko russia</span></td>
<td>marina lomazov / ukraine / usa</td>
<td>dmitri teterin russia</td>
<td>giampaolo stuani italy</td>
</tr>
<tr>
<td>1993</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">amir katz israel</span></td>
<td>not awarded</td>
<td>seizo azuma and japan yuko nakamichi japan</td>
<td>katsunori ishii japan</td>
</tr>
<tr>
<td>1991</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">ilya itin russia</span></td>
<td>anders martinson usa</td>
<td>markus pawlik germany</td>
<td>jean - françois bouvery france</td>
</tr>
<tr>
<td>1989</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">sergei babayan armenia ( ussr )</span></td>
<td>nicholas angelich usa</td>
<td>megumi kaneko japan</td>
<td>pascal godart france</td>
</tr>
<tr>
<td>1987</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">thierry huillet france</span></td>
<td>asaf zohar israel</td>
<td>jonathan bass usa</td>
<td>beatrice hsin - chen long / taiwan / china</td>
</tr>
<tr>
<td>1985</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">daejin kim south korea</span></td>
<td>benedetto lupo italy</td>
<td>hélène jeanney france</td>
<td>neil rutman usa</td>
</tr>
<tr>
<td>1983</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">youngshin an south korea</span></td>
<td>mayumi kameda japan</td>
<td>stéphane lemelin canada</td>
<td>roy kogan usa</td>
</tr>
<tr>
<td>1981</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">philippe bianconi france</span></td>
<td>dan riddle usa</td>
<td>rémy loumbrozo france</td>
<td>roy kogan usa</td>
</tr>
<tr>
<td>1979</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">edward newman usa</span></td>
<td>jean - yves thibaudet france</td>
<td>angela hewitt canada</td>
<td>frederick blum usa</td>
</tr>
<tr>
<td>1977</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">nathalie bera - tagrine france</span></td>
<td>barry salwen usa</td>
<td>douglas montgomery usa</td>
<td>laura silverman usa</td>
</tr>
<tr>
<td>1975</td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">john owings usa</span></td>
<td>julian martin usa</td>
<td>john - patrick millow france</td>
<td>roe van boskirk usa</td>
</tr>
</table>
</div>
<hr/>
<div class="step">
<div class="step-title">Step 2: Select rows where 'year' is 1999 or 2000.</div>
<div class="content" id="step-0">
<table>
<tr>
<td>year</td>
<td>first</td>
<td>second</td>
<td>third</td>
<td>fourth</td>
</tr>
<tr>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">1999</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">antonio pompa - baldi italy</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">vassily primakov russia</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">shoko inoue japan</span></td>
<td><span class="highlighted-cell" style="background-color:yellow;" title="Used in transformation">sean botkin usa</span></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 class="content" id="step-1">
<table>
<tr>
<td>year</td>
<td>first</td>
<td>second</td>
<td>third</td>
<td>fourth</td>
</tr>
<tr>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">1999</span></td>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">antonio pompa - baldi italy</span></td>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">vassily primakov russia</span></td>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">shoko inoue japan</span></td>
<td><span class="highlighted-cell" style="background-color:#90EE90;" title="Used in transformation">sean botkin usa</span></td>
</tr>
</table>
</div>
</div>
<hr/>
</div>
</div>
<hr/>
</body></html>
|