Japanese Cities' Names

My solution:

SELECT NAME 
FROM   CITY 
WHERE  COUNTRYCODE = "JPN"; 

Japanese Cities' Attributes

My solution:

SELECT * 
FROM   CITY 
WHERE  COUNTRYCODE = "JPN"; 

Select By ID

My solution:

SELECT * 
FROM   CITY 
WHERE  ID = 1661; 

Select All

My solution:

SELECT * 
FROM   CITY; 

Revising the Select Query II

My solution:

SELECT NAME 
FROM   CITY 
WHERE  POPULATION > 120000 
       AND COUNTRYCODE = "USA"; 

Revising the Select Query I

My solution:

SELECT * 
FROM   CITY 
WHERE  POPULATION > 100000 
       AND COUNTRYCODE = "USA"; 

legsCount

My solution:

DROP PROCEDURE IF EXISTS legsCount; 

CREATE PROCEDURE legsCount() 
  SELECT SUM(IF(type = "human", 2, 4)) AS summary_legs 
  FROM   creatures 
  ORDER  BY id;