| <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; } | |
| .sql-command { background-color: #f0f0f0; padding: 10px; border-left: 4px solid #4CAF50; font-family: monospace; white-space: pre-wrap; } | |
| </style> | |
| </head><body> | |
| <hr> | |
| <h3><span>Statement:</span> shanghai pudong international airport ranked 3rd in total cargo with 2939157 metric tonnes</h3> | |
| <h3>Input Table: world 's busiest airports by cargo traffic</h3> | |
| <div class="step"> | |
| <table> | |
| <tr><td>rank</td><td>airport</td><td>code_(iata_/_icao)</td><td>total_cargo_(metric_tonnes)</td><td>%_change</td></tr><tr><td>1</td><td>hong kong international airport</td><td>hkg / vhhh</td><td>4062261</td><td>2.2%</td></tr><tr><td>2</td><td>memphis international airport</td><td>mem / kmem</td><td>3916535</td><td>2.5%</td></tr><tr><td>3</td><td>shanghai pudong international airport</td><td>pvg / zspd</td><td>2939157</td><td>5.3%</td></tr><tr><td>4</td><td>incheon international airport</td><td>icn / rksi</td><td>2456724</td><td>3.3%</td></tr><tr><td>5</td><td>ted stevens anchorage international airport</td><td>anc / panc</td><td>2449551</td><td>3.7%</td></tr><tr><td>6</td><td>dubai international airport</td><td>dxb / omdb</td><td>2267365</td><td>3.1%</td></tr><tr><td>7</td><td>louisville international airport</td><td>sdf / ksdf</td><td>2187766</td><td>0.9%</td></tr><tr><td>8</td><td>paris - charles de gaulle airport</td><td>cdg / lfpg</td><td>2150950</td><td>6.5%</td></tr><tr><td>9</td><td>frankfurt airport</td><td>fra / eddf</td><td>2066432</td><td>6.7%</td></tr><tr><td>10</td><td>narita international airport</td><td>nrt / rjaa</td><td>2006173</td><td>3.1%</td></tr><tr><td>11</td><td>miami international airport</td><td>mia / kmia</td><td>1929889</td><td>4.9%</td></tr><tr><td>12</td><td>singapore changi airport</td><td>sin / wsss</td><td>1898850</td><td>3.0%</td></tr><tr><td>13</td><td>beijing capital international airport</td><td>pek / zbaa</td><td>1787027</td><td>6.0%</td></tr><tr><td>14</td><td>los angeles international airport</td><td>lax / klax</td><td>1688351</td><td>3.7%</td></tr><tr><td>15</td><td>taiwan taoyuan international airport</td><td>tpe / rctp</td><td>1577728</td><td>3.1%</td></tr><tr><td>16</td><td>london heathrow airport</td><td>lhr / egll</td><td>1556203</td><td>0.7%</td></tr><tr><td>17</td><td>o'hare international airport</td><td>ord / kord</td><td>1512186</td><td>3.0%</td></tr><tr><td>18</td><td>amsterdam airport schiphol</td><td>ams / eham</td><td>1511824</td><td>2.4%</td></tr><tr><td>19</td><td>suvarnabhumi airport</td><td>bkk / vtbs</td><td>1345487</td><td>1.8%</td></tr><tr><td>20</td><td>john f kennedy international airport</td><td>jfk / kjfk</td><td>1283663</td><td>5.5%</td></tr><tr><td>21</td><td>guangzhou baiyun international airport</td><td>can / zggg</td><td>1246467</td><td>5.6%</td></tr><tr><td>22</td><td>indianapolis international airport</td><td>ind / kind</td><td>932105</td><td>2.7%</td></tr><tr><td>23</td><td>tokyo international airport</td><td>hnd / rjtt</td><td>909684</td><td>3.6%</td></tr><tr><td>24</td><td>shenzhen bao'an international airport</td><td>szx / zgsz</td><td>854901</td><td>3.5%</td></tr><tr><td>25</td><td>leipzig / halle airport</td><td>lej / eddp</td><td>846092</td><td>13.7%</td></tr><tr><td>26</td><td>doha international airport</td><td>doh / otbd</td><td>844532</td><td>4.5%</td></tr><tr><td>27</td><td>newark liberty international airport</td><td>ewr / kewr</td><td>743762</td><td>7.5%</td></tr><tr><td>28</td><td>cologne bonn airport</td><td>cgn / eddk</td><td>730054</td><td>0.5%</td></tr><tr><td>29</td><td>kansai international airport</td><td>kix / rjbb</td><td>723148</td><td>2.7%</td></tr><tr><td>30</td><td>kuala lumpur international airport</td><td>kul / wmkk</td><td>702227</td><td>0.1%</td></tr> | |
| </table> | |
| </div> | |
| <h3>SQL Command:</h3> | |
| <div class="sql-command">SELECT | |
| CASE | |
| WHEN (SELECT rank FROM table_sql WHERE airport = 'shanghai pudong international airport') = 3 | |
| THEN 'TRUE' | |
| ELSE 'FALSE' | |
| END;</div> | |
| </body></html> | |