zad1

select o.id_oso
from obecnosci o
join serie s on o.id_obe = s.id_obe
join strzaly st on s.id_ser = st.id_ser
join treningi t on o.id_tre = t.id_tre
join warunki w on t.data = w.data
where st.wynik = 10 and ( w.widocznosc ~= slaba_widocznosc() ) > 0
group by o.id_oso