Waiter: "Welcome! Would you like some sparkling water to start?" Customer: "No, thank you. I don't want any drinks right now. But tell me, do you have any vegetarian specials tonight?"

Even though we normally use any in questions, we use some when we are making an offer or a request ("Would you like some water?").

We use any for negative statements ("don't want any drinks") and for general questions where we don't know the answer ("do you have any specials?").