DD got a huge dispensation when she was 11 that she could have A (single) coke once a week. She doesn't have it every week, and most of the time it was a mini-can (not a 330ml, but the smaller cans as mixer size).
Realistically, she has the odd fizzy drink - mostly on special occasions or when out for a meal. But she will ask for a Britvic OJ more often than a fizzy drink, or look for an iced-tea based drink in the shops a lot. Or plain or sparkling water. She likes J2O's as well as more special occasion drinks.
Sometimes we make squash using sparkling water rather than tap water.
At home, it is mostly water, squash, milk or hot chocolate, with the odd cup of tea thrown in, and rare fizzy drinks. She likes some fruit smoothies - both homemade and shop bought - on occasion.
She has cut the amount of fizzy drinks herself in the past couple of years - particularly in 6th class before leaving primary, and markedly so this year in 1st year of Secondary school.
I echo others about like adults having wine - its not an everyday thing, and it does tend to be rationed even when available. But her teeth are good, and we are happy for her to have some, in moderation - and have discussed it with her in that context, having some in moderation. But we have various cans of fizzy drinks at times in the cupboards, and some J2Os, and some beer and wine etc - and they can sit there for quite a while.
Even when we do have them, we tend to just open a can, rather than a bottle, as that is plenty for 1 person. And a bottle usually either goes flat and gets wasted, or we all feel a bit ick after drinking it all. So a variety of cans works better for us.