Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Question

SQL Question

From: <stevenleongusa_at_gmail.com>
Date: Mon, 24 Sep 2007 14:40:01 -0700
Message-ID: <1190670001.650654.146590@w3g2000hsg.googlegroups.com>


I have given the following question. I need help on this.

Given a schema for a stock trades table that looks like:

*stocktrades (*

Assuming the above table holds data for exactly one day of information
(midnight to 11:59.59 PM), write the query needed to summarize the stock trades data into the following table that holds weighted average
price for each stock for every hourly period during that day:

*avgtrades (*

Received on Mon Sep 24 2007 - 16:40:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US