I get the total number after grouping by and the total of the filled rows after grouping by.

```
SELECT X, COUNT(*) as total
FROM table 
WHERE Y IS NULL 
GROUP BY X

```

This for example results in row 1 has 1000 values

```
SELECT X, COUNT(*) as total
FROM table
GROUP BY X

```

this for examples results in row 1 has 500 values.

Now what I want to get is the proportion. Meaning I want to get the total of my group by statement divided by the total of my group by statement with the WHERE filter. Is this possible?