Online Course Support

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;

Similar Posts