SQL Question

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

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

*stocktrades (*

• symbol string, -- stock symbol*
• shares integer, -- number of shares traded*
• price float, -- price of the stock for this trade*
• timestamp integer -- timestamp in hhmmss 24-hour format*
• -- i.e., 000000 = midnight, 235959 = 11:59.59 PM*
  *)*
  

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 (*

• symbol string, -- stock symbol*
• period integer, -- a one or two digit value representing*
• -- the hourly period of the trades*
• -- (0 = 000000-005959, 1 = 010000 - 015959...)*
• avgprice float -- weighted average price is the sum of*
• -- total dollars (price*shares) / total*
• -- number of shares traded in any interval*