Hey everyone, I've been using ChatGPT for a few months now to help with SQL query generation and data analysis planning. It's been mostly great, but lately I've run into something really frustrating and was wondering if others have seen this.
I'll give it a clear, multi-part instruction, and it will just... skip one of the parts. For example, I asked it to:
1. Write a SQL query to find duplicate customer emails in a table.
2. Explain the logic behind the `GROUP BY` and `HAVING` clause it uses.
3. Suggest an alternative method using a window function.
It gave me a perfect query and a good explanation of the `GROUP BY`, but completely ignored the window function part. I had to ask again specifically for that. This happens a lot, especially when my prompts get a bit longer. It's like it hits a token limit or just loses track.
Here's another example from yesterday. I was trying to format some data for a report:
```sql
-- My prompt was: "Convert this date to 'YYYY-MM-DD' format and also extract the day of the week."
SELECT customer_id, order_date
FROM orders;
```
It correctly gave me the `DATE_FORMAT(order_date, '%Y-%m-%d')`, but no mention of `DAYOFWEEK()` or anything similar. It's not a huge deal, but it breaks my workflow when I have to double-check or reprompt for missing pieces.
Is this a known issue with the current version? I'm on the free tier, if that matters. Maybe I need to structure my prompts differently? I've tried numbering steps, using bullet points, and even saying "Please ensure you address all three points," but it still happens sometimes. Any tips or similar experiences?