All our Data Science projects include bite-sized activities to test your knowledge and practice in an environment with constant feedback.
All our activities include solutions with explanations on how they work and why we chose them.
Fetch name of all the countries from the country table whose name starts with A.
Fetch name of the all cities from the city table whose name ends with berg.
Fetch names of all countries with island anywhere in their name (case insensitive) from the country table.
Retrieve all the languages from the countrylanguage table that have exactly 5 characters.
Retrieve names of cities from the city table with San in their name, but it should not be starting with San.
List local names of countries from the country table whose LocalName contains a space.
Find distinct languages from the countrylanguage table that start with T and have exactly 7 characters.
Find names of countries from the country table whose names do not contain the letter a (case insensitive).
List names of countries from the country table whose names have exactly one a (case insensitive).
Fetch names of cities from the city table with names containing two consecutive o letters.
Fetch names and government forms of countries from the country table whose government forms do not start with Republic.
As a Project Author at DataWars, I dive into the world of data science and AI/ML with a millennial flair, constantly intrigued by the inner workings of technology. While I'm not crunching numbers, you'll find me cheering for my favorite cricket team.
