OK, I have a table with three columns that need analysis, one of which
is double and the others are integers. I need to display the
relationships among these three as well as the frequency distributions
of the records.

I can do all this relatively easily if I export the data to a file and
then import it into statistical software such as R, or if I just write
some relatively simple C++ or FORTRAN code.

What I want to know is whether or not there are features in SQL or in
MySQL that would make doing this any simpler. Is there, for example,
a function, or a kind of SQL statement that will produce a frequency
distribution of 3D vectors?

I ask because this goes well beyond the usual stuff I've done using
SQL, and I've heard about data mining (which I would intuitively
expect needs to do similar things). While statistics is old hat for
me, I haven't tried to do it in anything other than FORTRAN and C++.

Suggestions would be greatly appreciated.

Thanks

Ted