get_daily_summary sorting problem

[poblabs]

This is a fun project I find myself tinkering on a little bit at a time throughout the day.

One thing I noticed is that the tables sorting by "Total" wasn't working right. I played around with some queries but the total column still seems not sorted by highest to lowest.

[poblabs]

I'm playing around with some of the queries and I was able to get the totals to sort correctly but it breaks the hourly break-down of birds. I'll still keep playing around with it.

Here's an example below showing the totals aren't sorted

[mmcc-xx]

That's odd. I'll have a look too. SQL queries make my brain hurt.