Запрос к SQLite

SELECT DATE, CASE WHEN COUNT(*) > 1 THEN -1 ELSE MAX(country) END AS xxx
FROM someTable
GROUP BY DATE

SELECT DATE, CASE WHEN COUNT(DISTINCT *) > 1 THEN -1 ELSE MAX(country) END AS xxx
FROM someTable
GROUP BY DATE

SELECT DATE, CASE WHEN COUNT(DISTINCT country) > 1 THEN -1 ELSE MAX(country) END AS xxx
FROM someTable
GROUP BY DATE

CREATE TABLE `country_ru` (
    `_id`   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `name`  INTEGER NOT NULL,
    `id_color`  INTEGER NOT NULL
);

SELECT DATE, CASE WHEN COUNT(DISTINCT country) > 1 THEN -1 ELSE MAX(id_color) END AS COUNT
FROM high_day, country_ru GROUP BY DATE;

SELECT nstd.date, CASE WHEN nstd.DCNT > 1 THEN -1 ELSE cr.id_color FROM (
    SELECT DATE, COUNT(DISTINCT country) DCNT, MAX(country) MaxCountry
    FROM high_day
    GROUP BY DATE
) nstd JOIN country_ru cr ON nstd.MaxCountry = cr.`_id`

CREATE TABLE `country_color` (
    `_id`   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `r` INTEGER NOT NULL,
    `g` INTEGER NOT NULL,
    `b` INTEGER NOT NULL
);

CREATE TABLE `country_ru` (
    `_id`   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `name`  INTEGER NOT NULL,
    `id_color`  INTEGER NOT NULL
);

CREATE TABLE `high_day` (
    `_id`   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `country`   INTEGER NOT NULL,
    `date`  TEXT NOT NULL,
    `id_name`   INTEGER,
    `id_opisanie`   INTEGER
);

SELECT nstd.DATE, CASE WHEN nstd.DCNT > 1 THEN -1 ELSE cr.id_color END FROM (
    SELECT DATE, COUNT(DISTINCT country) DCNT, MAX(country) MaxCountry
    FROM #high_day
    GROUP BY DATE
) nstd JOIN #country_ru cr ON nstd.MaxCountry = cr._id