Users Table:

```
ID|Name|Deleted
1 |    |  N 
2 | b  |  Y 
3 | c  |  N
4 | d  |  N 

```

Deleted default value is 'N'

I want to order by id desc but I want to display deleted user last. 

i.e. when Deleted 'Y' should appear last