Iam very enthusiastic person who always finds ways to make myself Happy and being positive. I love learn coding and teach someone who hates programming
- ME Computer Science and Engineering,2010-2012
- ANNA UNIVERSITY Rank-36
--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? | |
SELECT name FROM country WHERE population between 500000 and 1000000; |