1. The latest scores from the Japanese Baseball League are in the table with sch
ID: 3712000 • Letter: 1
Question
1. The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Opponent, RunsFor, RunsAgainst) The data in this table is as follows: Team Opponent RunsFor RunsAgainst Dragons Carp Bay Stars Marines Ham Fighters Buffaloes1 Tigers Swallows Giants Hawks Golden Eagles 8 12 Lions Tigers Swallows Giants Hawks Dragons Carp Bay Stars Marines Buffaloes Ham Fighters 6 Golden Eagles Lions 12 What is the result of executing on this data the query: SELECT Team, Opponent FROM SCores WHERE Team LIKE '% %, OR Opponent LIKE 1% Identify, in the list below, a row of the result Bay Stars Giants o b) O c) d) Giants Bay Stars Marines Hawks Hawks MarinesExplanation / Answer
Answer is a.
In the where condition, the query is checking like '_i%'. This will result the names which has second letter as i.
In the table there are two rows with that result in the opponent column. Lions and Giants.But in the choice only Giants is listed.
Answer is Baystars Giants
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.