What are the names of all genres in alphabetical order, combined with its ratings?
SELECT g_name ,  rating FROM genre ORDER BY g_name
names of all genres = SELECT g_name; in alphabetical order = ORDER BY g_name; combined with its ratings = SELECT g_name, rating;