Using the World database, how many regions are in the continent of Antarctica? Display this number as “Number of Regions”. Display the name of the continent as ‘Continent’. Also display the grand total surface area as “Total Surface Area”
SQL is the language that is used to communicate with the database. With the help of SQL, data can be inserted, updated, and manipulated.
Query: SELECT COUNT(Region) AS number_of_regions
Query: SELECT continents as continents
Query: SELECT SUM(surface_area) AS total_surface_area