Question

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

a) SELECT * FROM movies ORDER BY movie_name ASC;
b) SELECT * FROM movies SORT movie_name;
c) SELECT * FROM movies ORDER movie_name;
d) SELECT * FROM movies GROUP BY movie_name;

Answer 1

The correct query to order a table of movies by name is 'SELECT * FROM movies ORDER BY movie_name ASC;'. This statement sorts the results by 'movie_name' in ascending order, which is the default sorting order in SQL.

Step-by-step explanation:

To order a table of movies by name in an SQL query, you would use the ORDER BY clause to sort the results. The correct query for this operation would be:

a) SELECT * FROM movies ORDER BY movie_name ASC;

This SQL statement selects all columns from the 'movies' table and orders the results by the 'movie_name' in ascending order, which is what ASC stands for. It is the default sorting order even if you do not explicitly specify it. Options b), c), and d) are not correct syntax for sorting query results in SQL.