Ten questions to test which AI assistant writes the best SQL
13 hours ago
· Context
· Let’s Compare Their SQL Skills!
· Round 1: Problem Solving (LeetCode SQL)
· Round 2: Business Logic
· Round 3: Query Optimization
· Summary
· What’s Next
Welcome to the first installment of my new series, ChatGPT vs. Claude vs. Gemini for Data Analysis. Throughout this series, I will compare these AI models on various data science and analytics tasks, aiming to help fellow data enthusiasts and professionals choose the best AI assistant for their needs.
Here are the specific models I will be comparing. I chose these three because they all offer a chatbot interface that is easily accessible and convenient for daily tasks. I used my subscriber accounts for the comparison (yes, I subscribed to Claude and Gemini Advanced last week for this article 😂).
ChatGPT 4o: Available to all ChatGPT users, but free users have a low usage limit. The Plus subscription is available at $20/month.
- Context window: 128k tokens
- Training data up to Oct 2023 (source)