-
Notifications
You must be signed in to change notification settings - Fork 169
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Code not working. #7
Comments
The SQL query you found appears to have some syntax errors. I'll correct it and check if it's wrong Here's the corrected SQL query:
Corrected WHERE YER >=2000 to WHERE year >= 2000 to compare the year correctly. This query should now work correctly to calculate the total snow precipitation (total_snow) and the maximum precipitation (max_precipitation) per year starting from 2000 in the STATION_DATA table. |
Kk @
The text was updated successfully, but these errors were encountered: