SQL Coding Interview With ChatGPT. Would You Pass It?

ChatGPT interviewed me about SQL coding and concepts.

LLM Interview | Image generated by AI. Gemini 3, 2025. https://gemini.google.com | Not Medium subscriber, read it here.

Introduction

Structured Query Language (SQL) has existed for about 50 years. It was initially developed in IBM labs in the 1970s, but it was standardized by organizations like ISO only in 1986/87.

I have a feeling that at one time or another during your data journey, you might have faced SQL. After all, despite all the languages existing these days, from Python to R, or from HTML to JavaScript, SQL has endured.

Thinking about why that is, I would point out a couple of things:

• It is simple to learn and to write
• It is stable and has few updates to learn over the years.
• It presents structured data, which is the easiest way to handle it.

As data scientists, we obviously need data for our projects. And not only data but datasets with rows and columns that can be handled and prepared for analytics and modeling.

Knowing all of that, be aware that knowing SQL is almost a requirement if you are or want to be a Data Scientist.

According to data from 365 Data Science, around 82% of data scientists reported using SQL as one of their primary tools. The same research shows that…