What's the difference and what's more appropriate in following cases:
We had a romantic dinner at the lake yesterday.
We had a romantic dinner by the lake yesterday.(On a plane)
I'd like to sit at the window.
I'd like to sit by the window.
Thank you in advance!