Table: tide_data
Columns: higher_harmonics
darwin
period
speed
doodson_coefficients
noaa

Question: What higher harmonics have an NOAA of 8?
SQL: SELECT "higher_harmonics" FROM tide_data WHERE "noaa" = '8'

Question: What is the speed of the higher harmonics that have an NOAA of 37?
SQL: SELECT "speed" FROM tide_data WHERE "noaa" = '37'

Question: What is the NOAA of the higher harmonics that have a Darwin of mn 4?
SQL: SELECT "noaa" FROM tide_data WHERE "darwin" = 'mn 4'

Question: What is the NOAA of the higher harmonics that have a Darwin of m sf?
SQL: SELECT "noaa" FROM tide_data WHERE "darwin" = 'm sf'

Question: Which higher harmonics have a speed of 0.0821373?
SQL: SELECT "higher_harmonics" FROM tide_data WHERE "speed" = '0.0821373'