-- ******************************
-- Exo 3.4 :
--     17   rows
--
SELECT *
FROM Medicament
WHERE coMed NOT IN (SELECT coMed FROM DetailVisite WHERE tpVis = "HOSPITALISATION")
AND prix > 100
UNION
SELECT *
FROM Medicament
WHERE coMed IN (SELECT coMed FROM DetailVisite WHERE tpVis = "PHYSIQUE")
ORDER BY libMed
;