Utilize the complete Strike Reports dataset as well as the list of Airports in United States of America dataset. Join the two datasets, the complete Strike Reports and the list of Airports in United States of America, to get each airport’s latitude and longitude. Create a new table that aggregates the data at the airport level
Sample Solution
