Question: If you need to order a table of movies by name, which query will work?

  1. SELECT \* FROM movies GROUP BY name
  2. SELECT \* FROM movies ORDER BY name
  3. SELECT \* FROM movies ORDER TABLE by name
  4. SELECT \* FROM movies FILTER BY name

Answer: The correct answer of the above question is Option B:SELECT \* FROM movies ORDER BY name