The words: at, by

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.

Correct phrase

I took my sister by the hand.

We travelled by night.

I live by the sea.