Загадка Эйнштейна SQL-запросом

With country as
    (select 1 as cnt_id, 'datch' as country  from dual
        union
    select 2 as cnt_id, 'norv' as country from dual
        union
    select 3 as cnt_id, 'sweed' as country from dual
        union
    select 4 as cnt_id, 'brit' as country from dual
        union
    select 5 as cnt_id, 'germ' as country from dual
    ),

    animal as
    (select 1 as an_id, 'fish' as animal  from dual
        union
    select 2 as an_id, 'dog' as animal from dual
        union
    select 3 as an_id, 'cat' as animal from dual
        union
    select 4 as an_id, 'bird' as animal from dual
        union
    select 5 as an_id, 'horse' as animal from dual
    ),

    cigar as
    (select 1 as ci_id, 'dunhi' as cigar  from dual
        union
    select 2 as ci_id, 'marlbo' as cigar from dual
        union
    select 3 as ci_id, 'rothma' as cigar from dual
        union
    select 4 as ci_id, 'PalMal' as cigar from dual
        union
    select 5 as ci_id, 'PhilMor' as cigar from dual
    ),

    color as
    (select 1 as col_id, 'yel' as color  from dual
        union
    select 2 as col_id, 'red' as color from dual
        union
    select 3 as col_id, 'blue' as color from dual
        union
    select 4 as col_id, 'gree' as color from dual
        union
    select 5 as col_id, 'whit' as color from dual
    ),

    address as
    (select 1 as ad_id, '1' as address  from dual
        union
    select 2 as ad_id, '2' as address from dual
        union
    select 3 as ad_id, '3' as address from dual
        union
    select 4 as ad_id, '4' as address from dual
        union
    select 5 as ad_id, '5' as address from dual
    ),

    drink as
    (select 1 as dr_id, 'tea' as drink  from dual
        union
    select 2 as dr_id, 'milk' as drink from dual
        union
    select 3 as dr_id, 'water' as drink from dual
        union
    select 4 as dr_id, 'beer' as drink from dual
        union
    select 5 as dr_id, 'cafe' as drink from dual
    ),

    mixx as  -- Декартово произведение
    (select *
    from country cnt, animal an, cigar ci, color col , address ad, drink dr ) -- count=15625

select  count( m.country) from mixx m ;

    На одной улице подряд стоят пять домов, каждый — своего цвета. 
В каждом живёт человек, все пять — разных национальностей. 
Каждый человек предпочитает уникальную марку сигарет, напиток и домашнее животное. 
Кроме того:

 1        Норвежец живёт в первом доме.
 2        Англичанин живёт в красном доме.
 3        Зелёный дом находится слева от белого, рядом с ним.
 4        Датчанин пьёт чай.
 5        Тот, кто курит Marlboro, живёт рядом с тем, кто выращивает кошек.
 6        Тот, кто живёт в жёлтом доме, курит Dunhill.
 7        Немец курит Rothmans.
 8        Тот, кто живёт в центре, пьёт молоко.
 9        Сосед того, кто курит Marlboro, пьёт воду.
10        Тот, кто курит Pall Mall, выращивает птиц.
11        Швед выращивает собак.
12        Норвежец живёт рядом с синим домом.
13        Тот, кто выращивает лошадей, живёт в синем доме.
14        Тот, кто курит Phillip Morris, пьет пиво.
15        В зелёном доме пьют кофе.

    Вопрос:

        Кто разводит рыбок?