>Bargain'''' WHEN price BETWEEN10and20THEN''''Average'''' ELSE''''Gift to impress relatives'''' ENDAS Range, Title FROM titles GROUPBY CASE WHEN price ISNULLTHEN''''Unpriced'''' WHEN price <10THEN''''Bargain'''' WHEN price BETWEEN10and20THEN''''Average'''' ELSE''''Gift to impress relatives'''' END, Title ORDERBY CASE WHEN price ISNULLTHEN''''Unpriced'''' WHEN price <10THEN''''Bargain'''' WHEN price BETWEEN10and20THEN''''