Question

Which SQL query lists all subscriptions with magazine names and sorts them alphabetically by magazine name?

a) SELECT magazine_name, last_name, first_name FROM subscriptions ORDER BY magazine_name ASC
b) SELECT magazine_name, first_name, last_name FROM subscriptions SORT BY magazine_name ASC
c) SELECT magazine_name, last_name, first_name FROM subscriptions SORT BY magazine_name
d) SELECT last_name, first_name, magazine_name FROM subscriptions ORDER BY magazine_name

Answer 1

The correct SQL query is option a) SELECT magazine_name, last_name, first_name FROM subscriptions ORDER BY magazine_name ASC, as it sorts the results alphabetically by the magazine_name in an ascending order.

Step-by-step explanation:

The correct SQL query to list all subscriptions with magazine names and sort them alphabetically by magazine name is:

SELECT magazine_name, last_name, first_name FROM subscriptions ORDER BY magazine_name ASC

This query selects the columns magazine_name, last_name, and first_name from the subscriptions table. The ORDER BY clause then organizes the result set alphabetically by magazine_name in ascending order, which is expressed by ASC (ascending is actually the default sort order in SQL and can be omitted, but it is often included for clarity).

Option a) is the correct choice because it follows the correct syntax for ordering the results in SQL.