set position of row by own on SQL : <p>I have a result of SQL like this </p>

<pre><code>status || value 
 green     3
 blue      39
 pink      2
 black     300
</code></pre>

<p>I want to change the row of blue and pink </p>

<p>I want to sort like this from <code>green, pink, blue, and black</code> for that row and value also
is that possible to the condition that row to be by own? </p>

<p>so the result will be like this </p>

<pre><code>status || value 
 green     3
 pink      2
 blue      39
 black     300
</code></pre>
