Which SELECT statements will return the same result as SELECT COUNT(type) AS num_types FROM fly.planes; Check all that apply.
Question 8
Which SELECT statements will return the same result as SELECT COUNT(type) AS num_types FROM fly.planes; Check all that apply.
1 point
- SELECT COUNT(*) AS num_types FROM fly.planes;
- SELECT COUNT(DISTINCT type) AS num_types FROM fly.planes;
- SELECT COUNT(*) AS num_types FROM fly.planes WHERE tz IS NULL;
- SELECT COUNT(ALL type) AS num_types FROM fly.planes;
- SELECT COUNT(*) AS num_types FROM fly.planes WHERE type IS NOT NULL;