-- mine -1
SELECT * FROM intersections_cr;
--a) attributes, morphology -2
--b) attributes, topography -3
SELECT * FROM MORPH_TO_SN_2_1;
SELECT * FROM ICDO_TOPOLOG;
--2) unmapped attributes combinatiobns by WHO -4
SELECT wc.* FROM WHO_CLEAN wc
left join intersections_cr cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE

WHERE cr.concept_id IS NULL;

--2) unmapped attributes combinatiobns by Seer -5
SELECT wc.* FROM WHO_TOPO_MORPHO wc
left join INTERSECTIONS_CR  cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE

WHERE cr.concept_id IS NULL;

--3) Unmapped disorders, which are not present in WHO -6
SELECT cr.* FROM INTERSECTIONS_CR cr
left join WHO_CLEAN wc ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE
WHERE wc.morph_code IS NULL;
--3) Unmapped disorders, which are not present in Seer -7
SELECT cr.* FROM WHO_TOPO_MORPHO wc
right join INTERSECTIONS_CR cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE
WHERE wc.morph_code IS NULL;

/*
select cr.* from WHO_CLEAN wc
join INTERSECTIONS_CR  cr on
wc.MORPH_CODE = cr.MORPHOLOGY_CODE and
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;

select cr.* from WHO_TOPO_MORPHO wc
join INTERSECTIONS_CR  cr on
wc.MORPH_CODE = cr.MORPHOLOGY_CODE and
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;
*/