Difference between revisions of "JOIN Quiz 2"
From SQLZOO
| Line 84: | Line 84: | ||
{Select the correct statement that shows the name of department which employs Cutflower | {Select the correct statement that shows the name of department which employs Cutflower | ||
|type="()"} | |type="()"} | ||
| + | - SELECT dept.name FROM teacher JOIN dept ON (dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower')) | ||
- SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE dept.id = (SELECT dept FROM teacher HAVING name = 'Cutflower') | - SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE dept.id = (SELECT dept FROM teacher HAVING name = 'Cutflower') | ||
| + | + SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE teacher.name = 'Cutflower' | ||
- SELECT dept.name FROM teacher JOIN dept WHERE dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower') | - SELECT dept.name FROM teacher JOIN dept WHERE dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower') | ||
| − | |||
| − | |||
- SELECT name FROM teacher JOIN dept ON (id = dept) WHERE id = (SELECT dept FROM teacher WHERE name = 'Cutflower') | - SELECT name FROM teacher JOIN dept ON (id = dept) WHERE id = (SELECT dept FROM teacher WHERE name = 'Cutflower') | ||
Revision as of 13:20, 18 July 2012
JOIN Quiz - part 2
| id | dept | name | phone | mobile |
|---|---|---|---|---|
| 101 | 1 | Shrivell | 2753 | 07986 555 1234 |
| 102 | 1 | Throd | 2754 | 07122 555 1920 |
| 103 | 1 | Splint | 2293 | |
| 104 | Spiregrain | 3287 | ||
| 105 | 2 | Cutflower | 3212 | 07996 555 6574 |
| 106 | Deadyawn | 3345 |
| id | name |
|---|---|
| 1 | Computing |
| 2 | Design |
| 3 | Engineering |
