List courses created on a certain day, sorted by row_status, availability and course_id

DECLARE @Qdate  SMALLDATETIME
SET @Qdate = '12/02/2010'
SELECT cm.course_id, cm.dtcreated,
cm.dtmodified, cm.available_ind, cm.row_status
FROM course_main cm
INNER JOIN course_users cu ON cm.pk1 = cu.crsmain_pk1
INNER JOIN users ON cu.users_pk1 = users.pk1
WHERE cm.row_status = '0' AND cm.course_id like '%SP2011' AND
cm.dtcreated BETWEEN @Qdate AND DATEADD(day,1,@Qdate)
ORDER BY cm.row_status DESC, cm.available_ind ASC, cm.course_id ASC