Introduction to Programming Using Visual Basic (10th Edition)

SQL statement

PART 3: SQL. 18. SQL: Using the Cities and Countries data on page 514, write SQL statements that (12 points) will produce the following: a. Show name. name and monetary unit fields of the countries table in ascending order by b. Write the SQL statement that will produce the following output Name Delhi Mumbai Pop2014 25.0 20.7 14.8 Pop2030 36.1 27.8 19.1 Calcutta c. Write the SQL statement that will produce the following output. Pop2014 41.8 119.7 127.1 Monetary Unit Peso Peso Name Argentina Mexico Japan d. Write an SQL statement that will show the records from Countries in descending order on 2014 population