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 ...
TechRepublic

Use SQL subselects to consolidate queries

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! We may earn from vendors via affiliate links or sponsorships. This might affect ...
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 ...