queries.txt

Nate Brennand: nsb2142
Matt Garbis: meg228

All data except the portofolio_statistics is real world data.

Code can be found here:
	https://github.com/nsb2142/Trading-Wheel


/* Highest Value any portfolio reaches */ 
SELECT 
	CS.user_id, 
	S.strategy_name, 
	MAX(T.portfolio_value)
FROM 
	trade T, 
	action A, 
	create_strategy CS, 
	strategy S
WHERE 
	CS.strategy_id = A.strategy_id 
	AND S.strategy_id = CS.strategy_id 
	AND T.trade_id = A.trade_id
GROUP BY 
	CS.user_id, 
	S.strategy_name;

/* Number of trades made by each strategy for each person */
Select DISTINCT 
	S.strategy_name, 
	CS.user_id, 
	COUNT(T.trade_id)
FROM create_strategy CS, 
	action A, 
	trade T, 
	strategy S
WHERE 
	CS.strategy_id = A.strategy_id 
	AND S.strategy_id = CS.strategy_id
	AND A.trade_id = T.trade_id 
GROUP BY 
	S.strategy_name, 
	CS.user_id;

/* Volume of each stock in 2009, in order */
Select Distinct 
	Q.security, 
	SUM(Q.volume)
FROM 
	query_data Q
WHERE
	extract(year from Q.time) = 2009
GROUP BY 
	Q.security;