March-Madness/sql_scripts.txt at master · DataScience-SacState/March-Madness · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
SHIT THAT DOESN’T WORK

SELECT * FROM TourneySeeds t WHERE Season >= 2014
join RegularSeasonCompactResults r
on t.Team = r.Team

SHIT THAT MOSTLY WORKS


SELECT *

FROM RegularSeasonDetailedResults

WHERE Season >= 2014

most winning teams regular season last two years

SELECT Wteam, COUNT(*)  AS wcount
FROM RegularSeasonCompactResults
WHERE Season >= 2014
GROUP BY Wteam
ORDER BY wcount DESC

winning score
SELECT Wteam, Wscore
    FROM RegularSeasonDetailedResults WHERE Season >= 2014;

avg winning score
SELECT Wteam, avg(Wscore) FROM RegularSeasonDetailedResults WHERE Season >= 2014 GROUP BY Wteam

avg losing score
SELECT Lteam, avg(Lscore) FROM RegularSeasonDetailedResults WHERE Season >= 2014 GROUP BY Lteam

field goal percentage

SELECT ((CAST(Wfgm AS FLOAT))/(CAST (Wfga AS FLOAT))) AS  Wfgp,((CAST(Lfgm AS FLOAT))/(CAST(Lfga AS FLOAT))) as Lfgp  FROM RegularSeasonDetailedResults WHERE Season >= 2014;

winning field goal percentage
SELECT Wteam,AVG((CAST(Wfgm AS FLOAT))/(CAST (Wfga AS FLOAT))) AS  Wfgp FROM RegularSeasonDetailedResults WHERE Season >= 2014 GROUP BY Wteam ORDER BY Wteam ASC;

losing field gaol percentage
SELECT Lteam,AVG((CAST(Lfgm AS FLOAT))/(CAST (Lfga AS FLOAT))) AS Lfgp FROM RegularSeasonDetailedResults WHERE Season >= 2014 GROUP BY Wteam ORDER BY Lteam ASC;