Congratulations! Now you are ready to create queries in SQL.

We will use the same database with tables **songs**, **singers** and **albums**.

## songs

<div style='height:300px;overflow:scroll'><table style='border-collapse: collapse'><tr><th>Id</th><th>title</th><th>singer_id</th><th>album_id</th><th>price</th></tr><tr><td>1</td><td>Dancing Queen</td><td>1</td><td>1</td><td>100</td></tr><tr><td>2</td><td>Highway to Hell</td><td>3</td><td>2</td><td>200</td></tr><tr><td>3</td><td>Toxic</td><td>2</td><td>4</td><td>30</td></tr><tr><td>4</td><td>Stairway to Heaven</td><td>4</td><td>5</td><td>510</td></tr><tr><td>5</td><td>Time</td><td>5</td><td>3</td><td>200</td></tr><tr><td>6</td><td>California Dreamin</td><td>6</td><td>NULL</td><td>1000</td></tr><tr><td>7</td><td>Baby One More Time</td><td>2</td><td>6</td><td>20</td></tr><tr><td>8</td><td>Thunderstuck</td><td>3</td><td>8</td><td>400</td></tr><tr><td>9</td><td>Time</td><td>7</td><td>9</td><td>120</td></tr><tr><td>10</td><td>Toxic</td><td>NULL</td><td>10</td><td>200</td></tr><tr><td>11</td><td>Touch Too Much</td><td>3</td><td>2</td><td>600</td></tr><tr><td>12</td><td>S.O.S.</td><td>1</td><td>1</td><td>80</td></tr><tr><td>13</td><td>Sometimes</td><td>2</td><td>6</td><td>900</td></tr><tr><td>14</td><td>Hollow Memories</td><td>8</td><td>NULL</td><td>770</td></tr><tr><td>15</td><td>Money</td><td>5</td><td>3</td><td>400</td></tr><tr><td>16</td><td>Billie Jean</td><td>9</td><td>12</td><td>1200</td></tr><tr><td>17</td><td>Blinding Lights</td><td>10</td><td>13</td><td>100</td></tr><tr><td>18</td><td>You Rock My World</td><td>9</td><td>14</td><td>900</td></tr><tr><td>19</td><td>We Are the Champions</td><td>NULL</td><td>NULL</td><td>300</td></tr><tr><td>20</td><td>Get It Hot</td><td>3</td><td>2</td><td>700</td></tr></table></div>

<div style='height:300px;overflow:scroll'><table style='border-collapse: collapse'><tr><th>Id</th><th>title</th><th><th>year</th></tr><tr><td>1</td><td>ABBA Gold</td><td>2008</td></tr><tr><td>2</td><td>Highway to Hell</td><td>1979</td></tr><tr><td>3</td><td>The Dark Side of the Moon</td><td>1973</td></tr><tr><td>4</td><td>In the Zone</td><td>2003</td></tr><tr><td>5</td><td>Led Zeppelin IV</td><td>1971</td></tr><tr><td>6</td><td>Baby One More Time</td><td>1998</td></tr><tr><td>7</td><td>Little Queen</td><td>1977</td></tr><tr><td>8</td><td>The Razors Edge</td><td>1990</td></tr><tr><td>9</td><td>Inception</td><td>2010</td></tr><tr><td>10</td><td>Hollow Mushmellow</td><td>NULL</td></tr><tr><td>11</td><td>Forever Young</td><td>1984</td></tr><tr><td>12</td><td>Thriller</td><td>1982</td></tr><tr><td>13</td><td>After Hours</td><td>NULL</td></tr><tr><td>14</td><td>Invincible</td><td>2001</td></tr><tr><td>15</td><td>Future Nostalgia</td><td>2020</td></tr></table></div>

<div style='height:300px;overflow:scroll'><table style='border-collapse: collapse'><tr><th>Id</th><th>naming</th><th>info</th></tr><tr><td>1</td><td>ABBA</td><td>Band</td></tr><tr><td>2</td><td>Britney Spears</td><td>Solo</td></tr><tr><td>3</td><td>AC/DC</td><td>Band</td></tr><tr><td>4</td><td>Led Zeppelin</td><td>Band</td></tr><tr><td>5</td><td>Pink Floyd</td><td>Band</td></tr><tr><td>6</td><td>The Mammas & The Pappas</td><td>NULL</td></tr><tr><td>7</td><td>Bee Gees</td><td>Band</td></tr><tr><td>8</td><td>Mushmellow</td><td>Band</td></tr><tr><td>9</td><td>Michael Jackson</td><td>Solo</td></tr><tr><td>10</td><td>The Weeknd</td><td>Solo</td></tr><tr><td>11</td><td>Lady Gaga</td><td>Solo</td></tr><tr><td>12</td><td>Scorpions</td><td>Band</td></tr><tr><td>13</td><td>Katy Perry</td><td>Solo</td></tr></table></div>

If you're an expert in creating queries for a single table, improve your knowledge! Let's start accessing and manipulating two and more tables. During the course, you'll learn how to work with special statements, what is the join and how to use it, and also will practice a lot!

We shall take a look at the database we'll work with and how we can create a query inside another query.

Learn how to join and work with multiple tables.

Try creating queries with no limits on how you should do that. Use all your knowledge from previous chapters!

Challenge: Albums with Two Songs

songs

albums

singers

Рішення

Challenge: Albums with Two Songs

songs

albums

singers

Рішення