how do I combine the results of these queries into columns? join is not suitable, because then in the on condition you will need to compare the id and the grouping will be broken, and union joins into strings. I want to get 4 columns in the result set. is it possible to modify the union operator in some way?
select count (num_zaprosa), num_zaprosa
from osn_sredstva
where num_zaprosa is not null
group by num_ zaprosa
select count (num_otveta), num_otveta
from osn_sredstva
where num_otveta is not null
group by num_otveta
1