3 Points to Check First in AI-Generated SQL

Things to check before hitting the execute buttonWhen you have AI write SQL and execute it, it returns numbers without any ...

The time I trusted AI with SQL aggregation and my boss pointed out the mistake

It all started with my usual monthly aggregation.I asked AI to write the SQL for aggregating sales by customer.I needed to aggregate sales by customer for my monthly report. As usual, I told ChatGPT, ...
TES

IB Computer Science 2027 – A3.3.4 SQL Aggregate Functions – Lesson & Worksheet

IB DP Computer Science 2027 A3.3.4 SQL Aggregate Functions lesson and worksheet for the new 2027 syllabus. A classroom-ready resource designed to help Higher Level students construct SQL calculations ...
Ars Technica

Why doesn't SQL have a mode() aggregate?

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...