Traveller

目录Using NULLTeachers and DepartmentsUsing NULLTeachers and Departments1.List the teachers who have NULL for their department.SELECT nameFROM teacherWHERE dept IS NULL2.Note the INNER JOIN misses the teachers with no department and the depa

The JOIN operationJOIN and UEFA EURO 20121.Modify it to show thematchidandplayername for all goals scored by Germany.SELECT matchid, playerFROM goal WHERE teamid='GER'2.Show id, stadium, team1, team2 for just game 1012SELECT id, stadium,...

The nobel table can be used to practice more SUM and COUNT functions.1.Show the total number of prizes awarded.SELECT COUNT(winner) FROM nobel2.List each subject - just onceSELECT DISTINCT subject FROM nobel3.Show the total number of prizes a