If I run the following query against the Hurricanes table data below. What will be returned ? 

SELECT Category, MAX(Wind) AS MaxWind 

FROM Hurricanes

WHERE Category 2

GROUP BY Category

 

Transcribed Image Text:

Name Hanna Isaias Laura Marco Nana Sally Teddy DateFormed 2020-07-23 2020-07-30 2020-08-20 2020-08-20 2020-09-01 2020-09-11 2020-09-12 Category Wind 1 1 4 1 1 2 4 90 85 150 75 75 105 140 AirPressure Damage 973 987 937 991 994 965 945 875 5225 10000 10 10 7000 NULL Deaths 5 18 77 1 0 8 3 Name Hanna Isaias Laura Marco Nana Sally Teddy DateFormed 2020-07-23 2020-07-30 2020-08-20 2020-08-20 2020-09-01 2020-09-11 2020-09-12 Category Wind 1 1 4 1 1 2 4 90 85 150 75 75 105 140 AirPressure Damage 973 987 937 991 994 965 945 875 5225 10000 10 10 7000 NULL Deaths 5 18 77 1 0 8 3

Answer rating: 100% (QA)

If you run the query as it is then there would be syntax error since the line WHERE Category 2 is ... View the full answer