这个来自The American Heritage Dictionary of the English Language

应该是非常权威了：

Usage Note: When where is used to refer to a point of origin, the preposition from is required: Where did she come from? From where I sit, the situation looks bleak. When it is used to refer to a destination, the preposition to is generally superfluous: Where is she going (rather than<而不是> Where is she going to)? The place where they are going is beautiful. When it is used to refer to the location of a person, event, or structure, the use of at is widely regarded as regional or colloquial: Where is the station (not Where is the station at )? · Where is also used to mean “in which” as in Show me an example where government intervention in the market has worked. The Usage Panel, formerly dubious about this use of where, has come to accept it over the years. In our 2017 survey, 77 percent of the Panel accepted the example just given, and 81 percent accepted Sometimes the discussion degenerates into a situation where each person accuses the other of being illogical, a significant increase from the acceptance figures of 60 and 44 percent respectively for the same sentences in 2001. · Where is also used in instances where that might normally be expected, as in I don't see where they had much choice but to give up. The Usage Panel has less fondness for this usage. Only 49 percent of the Panel accepted this sentence in our 2017 survey. See Usage Note at why.

题主的问题，只要看几句红的就行