Posts

Showing posts from June, 2023

SQL Island: Dive into the Exciting World of SQL with an Engaging Adventure

Image
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'; 3) There is no way around getting a sword for myself. I will now try to find a friendly weaponsmith to forge me one. (Hint: You can combine predicates in the WHERE clause with AND) SQL Query   -  SELECT * FROM inhabitant WHERE state = ‘friendly’ AND job = ‘weaponsmith’; 4) Oh,...