[HackerRank|MySQL] Select All / Select By ID

Select All

Problem

Query all columns (attributes) for every row in the CITY table.
The CITY table is described as follows:

Solution

SELECT *
FROM CITY

---

Select By ID

Problem

Query all columns for a city in CITY with the ID 1661.

Solution

SELECT *
FROM CITY
WHERE ID = 1661