News for hackers. Stuff that matters.
Re:One Giant Leap for SQL: MySQL 8.0 Released by wesd on Wednesday April 25, 2018 @01:01PM (#16923572)
That example code seems overly complicated and redundant. Should the code be simpler like this:

  SELECT id
        , max(a) ma
         , count(*) Cnt
   FROM ...
  GROUP BY id
Re:One Giant Leap for SQL: MySQL 8.0 Released by MarkusWinand on Wednesday April 25, 2018 @01:13PM (#16923719)
The purpose of the example is to demonstrate functional dependencies based on grouped tables.