SQL

In this post, let me do some basic SQL from free data.

 

 

 

mysql> show tables;

 

 

 

mysql> select * from city limit 10;

 

 

mysql> select * from city where CountryCode like '%USA%' limit 10;

 

 

mysql> select * from city where Population > 6000000 and Population < 8000000;

 

 

mysql> select * from city where CountryCode like '%OR%' limit 10;

 

 

mysql> select * from city where Population < 500 order by Population desc;