Quiz9. 류현진과 커쇼 전 시즌 ERA 조회

[dolzi]

9. [류현진선수와 커쇼선수를 찾아내는 과정 SQL 쿼리] [Quiz9. SQL 쿼리] [실행화면 캡쳐]

[expediore]

9-1. select playerID, nameFirst from people where nameLast like 'ryu'; select playerID, nameFirst from people where nameLast like 'kers%';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[WooJHo]

select playerID, namefirst, namelast from people where namelast='ryu' or namelast like 'ker%';

SELECT playerID, yearID, ERA, W, L from pitching where playerID='kershcl01' or playerID='ryuhy01';

[SHINZIMIN]

SELECT playerID, nameFirst, nameLast FROM people WHERE nameLast = 'Ryu' OR nameLast = 'Kershaw';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[monimanimo]

select from people where namelast like ('ryu'); select from people where namelast like('%kersh%');

select playerid, yearid, era, w, l from pitching where playerid='ryuhy01' or playerid='kershcl01';

[hungrywoo]

9. SELECT * FROM people WHERE nameLast = 'Kershaw' OR nameLast = 'Ryu';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[echoe1009]

SELECT FROM pitching WHERE playerID LIKE 'ryuh%'; SELECT FROM pitching WHERE playerID LIKE 'kers%';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[dhEhdod]

SELECT * FROM people WHERE nameLast = 'Ryu' OR nameLast LIKE 'Kersh%';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' or playerID = 'kershcl01';

[aosdbfc]

SELECT playerID FROM people WHERE nameLast = 'Ryu'; SELECT playerID FROM people WHERE nameLast = 'KerShaw';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'kershcl01' OR playerID = 'ryuhy01';

[indianaPoly]

select * from people where nameLast like '%ryu%' or nameLast like '%kershaw%';

select playerID, yearID, ERA ,W, L from pitching where playerID = 'kershcl01' or playerID = 'ryuhy01';

[jjjjjjye]

SELECT playerID FROM people WHERE nameLast = 'ryu' OR nameLast LIKE 'kers%';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[last0331]

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[Y0nghwan]

SELECT playerID, nameLast FROM people WHERE nameLast LIKE '%kersh%' OR nameLast LIKE '%ryu%';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'kershcl01' OR playerID = 'ryuhy01';

[JJungEunnn]

SELECT playerID FROM people WHERE nameLast= 'RYU' OR nameLast like 'Kersh%';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID= 'ryuhy01' OR playerID = 'Kershcl01';

[KUSFTWOO]

SELECT playerID, nameFirst FROM people WHERE nameLast LIKE 'kers%';

SELECT playerID, nameFirst FROM people WHERE nameLast LIKE 'Ryu';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[BAEKDONGSEOK]

SELECT FROM people WHERE namefirst = 'Clayton'; SELECT FROM people WHERE namelast = 'RYU';

SELECT playerID, yearID, ERA, W, L FROM pitching WHERE playerID = 'ryuhy01' OR playerID = 'kershcl01';

[jeong1217]