Question
a.Create a table, parkTypeTraffic , from the pg2.np_yearlyTraffic table. Use the following specifications. b.Read only the rows from the input table where ParkType is National
a.Create a table, parkTypeTraffic, from the pg2.np_yearlyTraffic table. Use the following specifications.
b.Read only the rows from the input table where ParkType is National Monument or National Park.
c.Create two new columns named MonumentTraffic and ParkTraffic. The value of each column should be increased by the value of Count for that park type.
d.Format the new columns so that values are displayed with commas.
e.Create a listing report of parkTypeTraffic. Use Accumulating Traffic Totals for Park Types as the report title. Display the columns in this order: ParkType, ParkName, Location, Count, MonumentTraffic, and ParkTraffic.
- Where do I begin to get started?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started