Skip to content

Instantly share code, notes, and snippets.

View pallavisarwar's full-sized avatar

pallavisarwar

View GitHub Profile
@pallavisarwar
pallavisarwar / gist:aab8fb43c4031f4bf7a2d41e1a11f213
Last active June 20, 2024 05:27
databases-week1-exercises.sql
--1. What are the names of countries with population greater than 8 million?
SELECT name , Population
from city
where Population > 8000000
--2. What are the names of countries that have “land” in their names?
SELECT Name
from city
WHERE name like '%land%'