Quiz10. MLB 2019년 투수 탈삼진 TOP 10 기록 이름과 함께 조회

[dolzi]

10. [SQL 쿼리] [실행화면 캡쳐]

[hungrywoo]

10. SELECT people.nameFirst, people.nameLast, pitching.so AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = '2019' ORDER BY TOTAL_SO DESC LIMIT 10;

[echoe1009]

SELECT people.nameFirst, people.nameLast, t.TOTAL_SO FROM (SELECT playerID, SUM(SO) AS TOTAL_SO FROM pitching WHERE yearID = 2019 GROUP BY playerID ORDER BY TOTAL_SO DESC LIMIT 10) as t LEFT OUTER JOIN people ON t.playerID = people.playerID;

[aosdbfc]

QUIZ 10

SELECT people.nameFirst, people.nameLast, pitching.so AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = '2019' ORDER BY TOTAL_SO DESC LIMIT 10;

[expediore]

SELECT people.nameFirst, people.nameLast, SUM(SO) AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID Where yearID = 2019 GROUP BY pitching.playerID ORDER BY SUM(SO) DESC LIMIT 10;

[Y0nghwan]

SELECT people.nameFirst, people.nameLast, SUM(SO) AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE pitching.yearID = 2019 GROUP BY people.playerID ORDER BY TOTAL_SO DESC LIMIT 10;

[KUSFTWOO]

SELECT people.nameFirst, people.nameLast, pitching.SO AS K FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = 2019 ORDER BY K DESC LIMIT 10;

[indianaPoly]

select people.nameFirst, people.nameLast, sum(SO) as TOTAL_SO from pitching left outer join people on pitching.playerID = people.playerID where pitching.yearID = 2019 group by pitching.playerID order by TOTAL_SO DESC limit 10;

[WooJHo]

SELECT people.nameFirst, people.nameLast, sum(so) as TOTAL_SO from pitching left outer join people on pitching.playerID =people.playerID where yearID=2019 group by people.playerID order by TOTAL_SO DESC limit 10;

[JJungEunnn]

SELECT people.nameFirst, people.nameLast, pitching.so AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = '2019' ORDER BY TOTAL_SO DESC LIMIT 10;

[jjjjjjye]

#10 SELECT people.nameFirst, people.nameLast, SUM(SO) AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = 2019 GROUP BY pitching.playerID ORDER BY TOTAL_SO DESC LIMIT 10;

[monimanimo]

SELECT people.nameFirst, people.namelast, pitching.so as TOTAL_SO FROM pitching left outer join people on pitching.playerid=people.playerID where yearid= '2019' order by TOTAL_SO DESC limit 10;

[dhEhdod]

SELECT people.nameFirst, people.nameLast, SUM(SO) AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = 2019 GROUP BY pitching.playerID ORDER BY TOTAL_SO DESC LIMIT 10;

[BAEKDONGSEOK]

SELECT people.nameFirst, people.nameLast, SUM(SO) AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE pitching.yearID = 2019 GROUP BY people.playerID ORDER BY TOTAL_SO DESC LIMIT 10;

[SHINZIMIN]

SELECT people.nameFirst, people.nameLast,SUM(SO) AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = '2019' GROUP BY people.playerID ORDER BY TOTAL_SO DESC LIMIT 10;

[last0331]

SELECT people.nameFirst, people.nameLast, SO AS TOTAL_SO FROM pitching LEFT OUTER JOIN people ON pitching.playerID = people.playerID WHERE yearID = '2019' ORDER BY SO DESC LIMIT 10;