I recently updated to 19.0 of the IDE from 16.0 and basic aggregrate queries are returning blank results:

SELECT Amount FROM Opportunity returns results
SELECT AVG(Amount) FROM Opportunity returns an empty result

Is there something I'm missing?

Is it possible to access fields of another object based on just an ID?  For instance, through SOQL i get a list of opportunity IDs with owner IDs.  Can I get to User fields like department, division, etc. using just the owner ID without needing another SOQL query?

I recently updated to 19.0 of the IDE from 16.0 and basic aggregrate queries are returning blank results:

SELECT Amount FROM Opportunity returns results
SELECT AVG(Amount) FROM Opportunity returns an empty result

Is there something I'm missing?