ls
cd public/
ls
cd ..
ls
cd src
ls
cd ..
ls
cd ..
ls
cd data
ls
cd var
ls
cd ww
cd www
ls
cd html
ls
cd ..
cd ..
cd ..
ls
cd home
ls
cd ..
ls
cd srv
ls
cd ..
cd ~
ls
cd .data
ls
del leig.db
delete leig.dgb
delete leig.db
rm leig.db
ls
use leegman.db
ls
sqllite3
sqlite3
sqlite3
sqlite3
sqlite3
ls
sqlite3
sqlite
ls
sqlite
ls
sqlite leegman.db
sqlite
cd .data
ls
sqlite
sqlite3
sqlite3
ls
cd .data
ls
sqlite3
ls
cd .data
sqlite3
cd .data
sqlite3
ls
cd .data
sqlite3
ls
sqlite3
ls
sqlite3
ls
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
ls
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
select * from Goals where gameid = 21;
cd .data
sqlite3
cd .data
sqlite3
SELECT *, (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore > awayteamscore) OR (g.awayteamid = t.id AND hometeamscore < awayteamscore)) Wins, (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore < awayteamscore) OR (g.awayteamid = t.id AND hometeamscore > awayteamscore)) Losses, (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore < awayteamscore) OR (g.awayteamid = t.id AND hometeamscore > awayteamscore)) AND resulttype > 1 OTLosses (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore > awayteamscore) OR (g.awayteamid = t.id AND hometeamscore < awayteamscore)) * 2 Points from Teams t ORDER by Wins DESC;
SELECT *, (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore > awayteamscore) OR (g.awayteamid = t.id AND hometeamscore < awayteamscore)) Wins, (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore < awayteamscore) OR (g.awayteamid = t.id AND hometeamscore > awayteamscore)) Losses, (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore < awayteamscore) OR (g.awayteamid = t.id AND hometeamscore > awayteamscore) AND resulttype > 1) OTLosses (SELECT count(id) FROM Games g WHERE (g.hometeamid = t.id AND hometeamscore > awayteamscore) OR (g.awayteamid = t.id AND hometeamscore < awayteamscore)) * 2 Points from Teams t ORDER by Wins DESC;
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
select * from Goals where gameid = 60;
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
ls
copy leegman.db leeg911.db
cp leegman.db leeg911.db
ls
cd .data
sqlite3
cd .data
sqlite3
.tables
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
show tables;
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
select * from Players where fname = 'Joe';
select * from Players where fname = 'Joe';
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
select * from games where id = 390;
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
sqlite3
cd .data
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
cd .data
sqlite3
