MySQL query order by multiple items

SELECT some_cols
FROM prefix_users
WHERE (some conditions)
ORDER BY pic_set DESC, last_activity;

Note that we can place ASC or DESC after each column (like above does for pic_set), or leave it to default (like above’s last_activity-column).