I've got a table of master table of names/address and a detail table of
orders. I need to produce statistical counts, such as:
Last 6 Months orders by SCF (1st three digits of ZIP code)
Last 12 Months order by SCF
Last 6 Months $10-99 orders by SCF
Last 12 Months $10-99 orders by SCF
Plus a whole lot more of the same thing. In every case, I just need a
record count for everything that meets the criteria. Sometimes the criteria
will be in the master table, sometimes in the detail, and sometimes in a
combination of the two.
What is the most efficient way to generate this mess? Is this a single
Oracle Reports? Or do I need to run lots of queries first to generate the
individual statistics and store them in tables, then Report them?
Also welcome are places on the web to read up on this type of design....