> how much sugar water people buy, cases and cases

One confounding factor here is that oftentimes the price is only reasonable in bulk. I don't know about walmart, but around me the best deal typically is "buy 2 get 3 free". I rarely buy/drink soda, but on the occasions I buy at all I'll be getting many cases at a time.