Please use the above r code as a sample code to:

Plot the locations on the Canadian map where Population in 2006 is less than the last five digits of your student id number (use 12345). Make your query and plot your locations as points on your map using data obtained by your SQL query and other plotting tools. Submit your result as a .pdf file of the plot (remember to title the plot). Hint: after plotting using the above code, you may overlay points with this command: points(x=longitude, y=latitude, col='red', pch=16), where longitude and latitude are vectors of longitudes and latitudes resp.

Thank you for your help.

library(sp) library(rworldmap) ## ### Welcome to rworldmap ### ## For a short introduction type : vignette('rworldmap') library(rworldxtra) worldmap = getMap (resolution = "high") NrthAm = worldmap [which (worldmap$REGION=="North America"),] plot (NrthAm, col="white", bg="lightblue", xlim=c(-140,-55), ylim=c(55,60)) library(sp) library(rworldmap) ## ### Welcome to rworldmap ### ## For a short introduction type : vignette('rworldmap') library(rworldxtra) worldmap = getMap (resolution = "high") NrthAm = worldmap [which (worldmap$REGION=="North America"),] plot (NrthAm, col="white", bg="lightblue", xlim=c(-140,-55), ylim=c(55,60))