I'm using ChatGPT 4 (paid) and it has solved a few problems for me. (it sounds like you're using the free 3.5 and also having some pretty unrealistic expectatio

I'm using ChatGPT 4 (paid) and it has solved a few problems for me. (it sounds like you're using the free 3.5 and also having some pretty unrealistic expectations of ChatGPT like asking for a full implementation of a WAM) A mundane one: I have a list of lat-longs mapped to region codes, and I needed write a query to find the area of the convex hull of each region code. I knew how to do it in code, but I wanted a SQL answer. ChatGPT gave me the correct Redshift SQL. A more involved one: I needed to maximize match x people y groups, where people can rank their choices up to 3, but as soon as they accept the match, they drop out of the pool. Plus a bunch of different constraints. Sounds like a stable marriage problem. ChatGPT proposed the Gale-Shapley algorithm, which was the exact one I was looking for.