drop table StockTransaction

create table StockTransaction (

StockId varchar(10),

TransactionId int,

Amount money)

insert into StockTransaction values ('MSFT',1,500)

insert into StockTransaction values ('MSFT',1,2500)

insert into StockTransaction values ('MSFT',2,1000)

insert into StockTransaction values ('CSCO',1,2500)

insert into StockTransaction values ('CSCO',1,2500)

insert into...