<div style='height:300px;overflow:scroll;'><table style='border-collapse: collapse'><tr><th>id</th><th>name</th><th>continent</th><th>region</th><th>surfacearea</th><th>capital</th><th>population</th></tr><tr><td>1</td><td>Japan</td><td>Asia</td><td>Eastern Asia</td><td>377829</td><td>Tokyo</td><td>126714000</td>
</tr><tr><td>2</td><td>Latvia</td><td>Europe</td><td>NULL</td><td>64589</td><td>Riga</td><td>2424200</td>
</tr><tr><td>3</td><td>Mexico</td><td>North America</td><td>Central America</td><td>1958201</td><td>Mexico City</td><td>98881000</td>
</tr><tr><td>4</td><td>Netherlands</td><td>Europe</td><td>Western Europe</td><td>41526</td><td>Amsterdam</td><td>15864000</td>
</tr><tr><td>5</td><td>Portugal</td><td>Europe</td><td>Southern Europe</td><td>91982</td><td>Lisbon</td><td>9997600</td>
</tr><tr><td>6</td><td>Sweden</td><td>Europe</td><td>Nordic Countries</td><td>449964</td><td>Stockholm</td><td>NUll</td>
</tr><tr><td>7</td><td>Ukraine</td><td>Europe</td><td>Eastern Europe</td><td>603700</td><td>Kyiv</td><td>50456000</td>
</tr><tr><td>8</td><td>United States</td><td>North America</td><td>NULL</td><td>9363520</td><td>Washington</td><td>278357000</td>
</tr><tr><td>9</td><td>Thailand</td><td>Asia</td><td>NULL</td><td>513115</td><td>Bangkok</td><td>61399000</td>
</tr><tr><td>10</td><td>Paraguay</td><td>South America</td><td>North America</td><td>406752</td><td>Asunción</td><td>5496000</td>
</tr><tr><td>11</td><td>Philippines</td><td>Asia</td><td>Southeas Asia</td><td>300000</td><td>Manila</td><td>75967000</td>
</tr><tr><td>12</td><td>New Zealand</td><td>Oceania</td><td>Australia and New Zealand</td><td>270534</td><td>Wellington</td><td>18886000</td>
</tr><tr><td>13</td><td>Norway</td><td>Europe</td><td>Nordic Countries</td><td>323877</td><td>Oslo</td><td>4478500</td>
</tr><tr><td>14</td><td>Monaco</td><td>Europe</td><td>Western Europe</td><td>1.50</td><td>Monaco</td><td>NUll</td>
<tr><td>15</td><td>Malta</td><td>Europe</td><td>Southern Europe</td><td>316</td><td>Valletta</td><td>380200</td>

</tr></table></div>

This course is for you if you are new to SQL, you want to quickly learn how to get the most out of SQL and you want to learn how to use SQL in your own application development.

In this section, we will learn how to sort retrieved data using the ORDER BY clause. This clause, which must be the last in the SELECT statement, can be used to sort data on one or more columns as needed.\n

In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.

This section has long execution init script

Challenge

Lösung