I asked it to generate a SQL query with a bit of python, as the database schema is huge and unknown to me, obviously I checked it for glaring errors etc. I went back and clarified a couple of basic points. It then told me what I was doing was completely wrong, generated new code that worked is a different way, with a different edge case missed.

It’s literally stack overflow but arguing with itself