I have a table with image column.
In that column - the values are the image URLs.
Now I want to get all the rows from the table in the following order:
first - the rows with images, ordered by id.
second - the rows without images, ordered by id.

I tried this code (I found it somewhere):

```
ORDER BY CASE WHEN image IS NULL THEN 0 ELSE 1 END, id DESC

```

but it doesn't work.

can you help me with it?

Thanks!