Install an SQL environment to work with $($SQLite is preferred in this class$).$

Create a new SQL script named world$\_$cities.sql$.$

Write an SQL statement to create a table named 'cities'. This table should have the following columns:

$\text{'}$id$\text{'}$: a unique identifier for each city $($primary key$)\text{'}$name$\text{'}$: the name of the city'population': the population of the city'country': the country where the city is located

Insert data into the 'cities' table. This data can be real or made up$,$ but should include at least $10$ different cities from at least $5$ different countries. Be sure to include a mix of small and large cities.

Write SQL statements to perform the following tasks, and add comments to your script explaining what each statement does:

Select all cities in your tableSelect all cities in a specific country $($of your choice$)$Update the population of a specific cityDelete a specific city from the table