select sum (iif(country=="Россия", 1, 0)) из_россии, ;
  sum (iif(country=="Россия", 0, 1)) не_из_россии, year ;
 FROM your_table GROUP BY year

CREATE CURSOR pribors (snamckp C(30), yeardoc N, country C(20) )

INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 1', 2000, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 2', 2010, 'США')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 1', 2008, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 2', 2008, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 1', 2008, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 3', 2010, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 2', 2008, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 3', 2008, 'Индия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 1', 2010, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 2', 2008, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 2', 2010, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 3', 2011, 'Россия')
INSERT INTO pribors (snamckp, yeardoc, country) VALUES ('Прибор 3', 2012, 'Россия')


 SELECT snamckp, yeardoc, COUNT(*) cnt ;
   FROM pribors ;
   WHERE country="Россия" ;
   GROUP BY snamckp, yeardoc ;
   ORDER BY snamckp, yeardoc ;
 INTO CURSOR cgr1 
 
 
SELECT cgr1
BROWSE