$\frac{7}{12}$

$100\%$

Project Requirements: Part $3($Use the World sample database found in your MySQL database$)$

Tasks: $3)$ points$]$:

For each of the SQL statements that you will write here, make sure to take a screenshot of each output for submission in a report format on Blackboard.

Write an SQL statement to display columns Id$,$ Name, and Population from the city table and limit results to the first $10$ rows only. Expected output:

$\backslash$table$[[$id$,$name,$|$ population$],[1,$Kabul,$1780000],[2,$Qandahar,$237500],[3,$Herat,$186800],[4,$Mazar$-$e$-$Sharif,$127800],[5,$Amsterdam,$731200],[6,$Rotterdam,$593321],[7,$Haag,$440900],[8,$Utrecht,$234323],[9,$Eindhoven,$201843],[10,$Tilburg,$193238]]$

Write an SQL statement to display columns Id Name, and Population from the city table and limit results to rows $31-40.$

Expected output:

$\backslash$table$[[$name$,$I population$],[$Alger$,2168000],[$Luanda$,2022000],[$Buenos Aires,$2982146],[$Sydney$,3276207],[$Melbourne$,2865329],[$Dhaka$,3612850],[$S$$o Paulo,$9968485],[$Rio de Janeiro,$5598953],[$Salvador$,2302832],[$Belo Horizonte,$2139125]]$