I like to go for readability.

So AND instead of &&.

OR instead of ||

etc...other than preference, I don't think SQL really cares which way you do it...

I also like to make my SELECT statements capitalized and columns,tables lowercase like this:

SELECT * FROM user WHERE user_id = 5;


Again, just preference.....