Which weather events had Fog or Rain?
select * from weather where events = "Fog" or events = "Rain"
Which had neither?
select * from weather where events != "Fog" and events != "Rain"
Limit the search to zip code 94107.
select * from weather where zip_code = 94107 and events != "Fog" and events != "Rain"
Just give the date.
select date from weather where zip_code = 94107 and events != "Fog" and events != "Rain"