How to count multiple count() in select section using as notation?

Question

MySQL

Hello.
For example, I want to calculate the percentage of selected fields through count(), but sql swears that count_id1 and count_id2 are unknown , although I designate them through as count_id1 and as count_id2

select  
 ...
count(table.id1) as count_id1,
count(table.id2) as count_id2,
round(sum(count_id1) /  sum(count_id2)  * 100, 1) as percent

from table
...

Answer 1

SELECT t1.*,
             round(sum(count_id1) /  sum(count_id2)  * 100, 1) as percent
FROM
(
select  
 ...
count(table.id1) as count_id1,
count(table.id2) as count_id2

from table
...
) AS t1

Answer 2

You cannot refer to these numbers, because you are naming the resulting column, not creating a variable.

...
count(table.id1) as count_id1,
count(table.id2) as count_id2,
...

Here is a working request:

SELECT round((SELECT COUNT(table.id1) FROM table) /  (SELECT COUNT(table.id2) FROM table)  * 100, 1) as percent