SQL Island: Dive into the Exciting World of SQL with an Engaging Adventure
SQL Island is an interactive educational game designed to teach SQL (Structured Query Language) in a fun and engaging way. Players embark on a virtual adventure where they solve puzzles, complete challenges, and master SQL concepts to progress through the game. It offers a hands-on experience to learn and practice SQL skills while exploring an exciting island-themed environment.
Questions and Answers
Tap Continue
1) It seems there are a few people living in these villages. How can I see a list of all inhabitants?
SQL Query -
SELECT *
FROM inhabitant;
2) Thank you, Edward! Okay, let’s see who is friendly on this island…
SQL Query -
SELECT *
FROM inhabitant
WHERE state = 'friendly';
FROM inhabitant
WHERE state = ‘friendly’
AND job = ‘weaponsmith’;
FROM inhabitant
WHERE state = ‘friendly’
AND job LIKE ‘%smith’;
5) No need to call me stranger! What’s my personid? (Hint: In former queries, the * stands for: all columns. Instead of the star, you can also address one or more columns (seperated by a comma) and you will only get the columns you need.)
FROM INHABITANT
WHERE name = ‘Stranger’;
FROM INHABITANT
WHERE name = ‘Stranger’;
7) Damn! No mon, no fun. There has to be another option to earn gold other than going to work. Maybe I could collect ownerless items and sell them! Can I make a list of all items that don’t belong to anyone? (Hint: You can recognize ownerless items by: WHERE owner IS NULL)
FROM ITEM
WHERE owner IS null;
8) Do you know a trick how to collect all the ownerless items?
FROM ITEM
WHERE owner = 20
11) I’d like to get the ring and the teapot. The rest is nothing but scrap. Please give me the two items. My personid is 15.
SET owner = 15
WHERE item = ‘ring’
OR item = ‘teapot’
SET name = ‘David’
WHERE personid = 20
FROM inhabitant
WHERE job = ‘baker’
ORDER BY gold DESC
FROM inhabitant
WHERE job = ‘pilot’
FROM village v
JOIN individual i ON v.chief = i.personid
FROM inhabitant
JOIN village ON village.villageid = inhabitant.villageid
WHERE village.name = 'Onionville'
FROM inhabitant
WHERE villageid = 3
AND gender = ‘f’
FROM inhabitant
WHERE job = ‘baker’
OR job = ‘dealer’
OR job = ‘merchant’
FROM inhabitant
GROUP BY state
ORDER BY AVG(inhabitant.gold)
WHERE name = ‘Dirty Diane’
Wrap-up
Congratulations! You have completed SQL island!!!! Now, try it on your own, print your certificate and display it above the mantel in a prominent position.
For real practice and to become more comfortable with SQL I would suggest running through SQL island until you do not need a walk-through like this. Sleep. Then pass it one more time without help. Here's the link to the SQL Island game: https://sql-island.informatik.uni-kl.de/
Other useful links-
1) Want to test your SQL skills? Click the link below to take the challenge:
https://360emergingtech.blogspot.com/2025/08/wrapper.html
2) Looking for real-life SQL interview questions? Check out this link: https://360emergingtech.blogspot.com/2023/01/sql-interview-questions.html
Comments
Post a Comment
datapedia24@gmail.com