Exercise : Early Independance

Which countries received their independence before 0 AD? Show both the name and the year. (Hint: BC years are negative values.)

+----------+-------------------+
| name     | independence_year |
+----------+-------------------+
| Ethiopia |             -1000 |
| Japan    |              -660 |
| China    |             -1523 |
+----------+-------------------+
3 rows in set (0.00 sec)

Exercise Solution

SELECT name, independence_year
FROM countries
WHERE independence_year < 0;