at, by in English – Common Errors

How to use at and by correctly

Correct phrase	Common error
We live in a village near Hamburg.	We live in a village by Hamburg.
Frank stayed at my place last weekend.	Frank stayed by me last weekend.
I stayed at my grandmother's (house) during the Easter holidays.	I stayed by my grandmother during the Easter holidays.
Emily lives with her mother.	Emily lives by her mother.

Here are some correct phrases:

• I took my sister by the hand.
• We travelled by night.
• I live by the sea.