SQL Island a Fun Way to Learn SQL

A walk-through with brief explanations

SQL Island is a fun introduction to learning and using SQL. Source content link, and click here to play the game.

Since you are reading this walk-through, chances are you’ve already found the game and require a little more assistance than the creators provided. So, let’s begin!

• Getting Started: Change the Language to English or Portuguese from German

Change the Language to English

• Pay attention to the tutorial and hit continue as needed. If there is no “continue”, you are expected to write within the input box.
• Basic SQL formatting should look similar the code directly below for readability. But, it is not required to function and the game is not picky.

SELECT SUM(column_name)
FROM table_name
WHERE CONDITION
GROUP BY column_name
HAVING (arithmetic function condition);

Questions and Answers

It seems there are a few people living in these villages. How can I see a list of all inhabitants?

SELECT * 
FROM inhabitant;

Return all with *

Thank you, Edward! Okay, let’s see who is friendly on this…