Introduction: What is SQL? What is the main purpose of the structured query language? What are SQL comments?
Body: Use the database ‘State_Capitals’, construct five SQL statements for the following:
What is Country Name and Country Population?
What is the capital city of California?
What is the capital with the least population? What is the one with the most population?
What is the size of the largest state? What is the size of the smallest state?
List the region name, state name and capital name for every state in the United States of America.
You must use either single line or block comments to document each of your query. At a minimum, you need:
Author Info,
Create Date,
Description,
Updated by,
Last updated date.
Example: What is Country Code and Country Name?
Conclusion: Summarize how joins have been used in the above SQL statements to deliver the right results. Summarize how you would use comments to document your codes.