Write a query in athena to count the number of stations


Problem

Write a query in Athena to count the number of stations that are not in the US or Canada. The first two characters of the station ID field indicate the country where the station is located. The country codes for the United States are US and the country code for Canada is CA.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Write a query in athena to count the number of stations
Reference No:- TGS03226608

Expected delivery within 24 Hours