SQLzoo 习题记录08-Using Null & Quiz

目录

Using Null

NULL, INNER JOIN, LEFT JOIN, RIGHT JOIN

• 1.
• 2.
• 3.
• 4.

Using the COALESCE function

• 5.
• 6.
• 7.
• 8.

Using CASE

• 9.
• 10.

Using Null Quiz

• 1. Select the code which uses an outer join correctly.
• 2. Select the correct statement that shows the name of department which employs Cutflower -
• 3. Select out of following the code which uses a JOIN to show a list of all the departments and number of employed teachers