4th IIUC Inter-University Programming Contest, 2005 G Forming Quiz Teams Input: standard input Output: standard output Problemsetter: Sohel Hafiz You have been given the job of forming the
1. Select the code which uses an outer join correctly SELECT teacher.name, dept.name FROM teacher LEFT OUTER JOIN dept ON (teacher.dept = dept.id) 2. Select the
1. You want to find the stadium where player ‘Dimitris Salpingidis’ scored. Select the JOIN condition to use: game JOIN goal ON (id=matchid) 2. You JOIN the tables goal and eteam in an SQL state