if i have this table:

name status
cris single
jasper single
apple married
rd single
jojo married

how can i create a new column that will show all single persons lined up at
the top. and would look like this.

NAME STATUS QUERY
cris single cris
jasper single jasper
apple married rd
rd single
jojo married

thanks in advance


--
technical newbie