| -- 1. What are the names of countries with population greater than 8 million? | |
| SELECT name from country WHERE Population > 8000000; | |
| -- 2. What are the names of countries that have “land” in their names? | |
| SELECT name from country where Name LIKE "%land%" | |
| -- 3. What are the names of the cities with population in between 500,000 and 1 million? |
| Exercises Week 2 | |
| --Exercise 3: Formula 1 | |
| -- Creating Team table | |
| CREATE TABLE Team ( | |
| name VARCHAR(100) PRIMARY KEY, | |
| country VARCHAR(100) |
By Jean Felix Nibishaka
The purpose of this database is to assist students in selecting courses that align with their future career aspirations. It helps students understand the possible careers for each course, the potential careers when combining courses, the duration required to complete their studies, the expected salary after graduation, and the challenges associated with each career.
