Question: I'm converting pdf files to images with ImageMagic, everything is ok until I use `-resize` option, then I get image with black background. I use this command:

```
convert -density 400 image.pdf -resize 25% image.png

```

I need to use `-resize` option otherwise I get really large image. Is there any other option which I can use to resize image or is there option to set background in white.

Answer: 
```
Select
    City,
    Sum(Money),
    Sum(Case When Age < 30 Then 1 Else 0 End),
    Sum(Case When Age > 30 Then 1 Else 0 End)
From
    table
Group By
    City

```
You can use this Query,

```
SELECT City, 
    SUM(Money), 
   SUM(case when Age < 30 then 1 else 0 end),
   SUM(case when Age > 30 then 1 else 0 end)
FROM tableA
GROUP BY City

```