- 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.
- *** Only include the SQL statements, not data ***
- 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.
Submit your project in a word document format. Your assignment should be at least two pages in length. APA Style is not required for this assignment.