Make sure you are in right database (nyse_demo.db in this case)
1) select * from stock_eod limit 10;
2) select * from companylist limit 10;
3) select cl.sector, cl.company_name, substr(s.transactiondate, 4) transactionmonth, sum(s.volume) monthlyvolume from companylist cl
join stock_eod s
on s.stockticker = cl.symbol
where s.transactiondate like ' 13'
group by cl.sector, cl.company_name, substr(s.transactiondate, 4)
order by sector, company_name, transactionmonth; Connect with me or follow me at
آی-ویدئو