I tried ChatGPT, a variant of the GPT-3 language model that is specifically designed for generating human-like text in a conversational context. And of course, like most of us, I wondered: can an AI do my job? And can it do it better than me?

I have 2 years of experience working as a Data Analyst and an Analytics Engineer. According to BBC Science Focus, ChatGPT has ingested 570 GB of data. So who writes better SQL?

Let’s play!

This game will be based on 3 LeetCode SQL challenges (one easy, two medium). I will write every solution first, and then send the exercise to ChatGPT and see which solution works best.

I will provide links to every challenge so you can try as well to beat ChatGPT.

Challenge 1 (Easy)

This challenge is called Customer placing the largest number of orders.

Here is the query I wrote:

WITH layer_1 AS (
  SELECT
    customer_number, COUNT(DISTINCT order_number) AS order_number
  FROM orders
  GROUP BY customer_number
)
SELECT customer_number
FROM layer_1
ORDER BY order_number…