Bill wrote: > mysql> SELECT count(*) AS n, AVG(ra_PS), AVG(decl_PS), chunkId > -> FROM Object > -> GROUP BY chunkId; > +----------------+-------------------------------+-------------------------------+ > | SUM(QS1_COUNT) | (SUM(QS3_SUM)/SUM(QS2_COUNT)) | (SUM(QS5_SUM)/SUM(QS4_COUNT)) | > +----------------+-------------------------------+-------------------------------+ > | 3738244 | 80.5458153658024 | 0.27024249373145 | > +----------------+-------------------------------+-------------------------------+ > 1 row in set (27.30 sec) Hmm. I guess we can't easily get transparency in the column headers here. But can we at least get the "n"? And what happened to the chunkId? -- Kian-Tat Lim, LSST Data Management, [log in to unmask] ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1