Hacker News new | past | comments | ask | show | jobs | submit login

This looks a little odd

   SELECT age, sum(civility) as total_civility
   FROM star_wars_universe
   ORDER BY ALL
   -- ORDER BY age, total_civility
there's no GROUP BY?

edit: (removed edit, I blew it, sorry)




Good catch! Fixed! Needed a group by all in there.




Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: