- 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.
Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now