[/URL]+-------------+
| Average lat |
+-------------+
| NULL |
+-------------+
1 row in set (0.08 sec)


i dont understand why this is null

what i'm trying to do is figure out the (max latitude + min latitude) / 2

table is zips

field is lat

i need to select take the upper half of the "lat"s but i cant figure out how to find the middle lattitude, as you may know with mysql i can't take the nice easy oracle path and avg(max(lat),min(lat))

This post was edited by Ideophobe on Mar 10 2016 06:21am

MariaDB [junk]> select avg(b.asdf) from ((select max(lat) asdf from zips where state_prefix like 'MO') a) inner join ((select min(lat) asdf from zips where state_prefix like 'MO') b);
+--------------------+
| avg(b.asdf) |
+--------------------+
| 36.040000915527344 |
+--------------------+
1 row in set (0.07 sec)



MariaDB [junk]> select avg(a.asdf) from ((select max(lat) asdf from zips where state_prefix like 'MO') a) inner join ((select min(lat) asdf from zips where state_prefix like 'MO') b);
+--------------------+
| avg(a.asdf) |
+--------------------+
| 40.560001373291016 |
+--------------------+
1 row in set (0.07 sec)


I DONT UNDERSTAND THIS SHIT'S DRIVING ME CRAZY

+---------------------+
| (b.asdf + a.asdf)/2 |
+---------------------+
| 38.30000114440918 |
+---------------------+
1 row in set (0.08 sec)


nevermind i guess this will work looking at it on the webpage helped

If you're using avg,I assume you wanted to union the max and min so you get the average of two rows?

This

select avg(lat) `Average lat` from (select max(lat) `lat` from zips where state_prefix like 'MO' UNION select min(lat) `lat` from zips where state_prefix like 'MO');