SELECT ?specialite ?label ((?moyennespecialite) AS ?moy) ?moyenneetu
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT ?specialite ((AVG(?note1)) AS ?moyennespecialite) ((COUNT(DISTINCT ?q1)) AS ?nbquestionspecialite)
        WHERE {
            ?adr1 sides:has_for_result ?note1 .
            ?adr1 sides:done_by ?etu .
            ?adr1 sides:correspond_to_a_question ?q1 .
            ?q1 sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
        }
        GROUP BY ?specialite
    } .
    {
        SELECT ?specialite ((AVG(?note)) AS ?moyenneetu) ((COUNT(DISTINCT ?q)) AS ?nbquestionItemEtu)
        WHERE {
            ?adr sides:has_for_result ?note .
            ?adr sides:done_by ?etudiant .
            ?adr sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
            FILTER(?etudiant = sides:etu12514)
        }
        GROUP BY ?specialite
    } .
    OPTIONAL {
        SELECT ?specialite str(?label) as ?label
        WHERE {
            ?specialite a sides:speciality.
            ?specialite rdfs:label ?label.
        }
        GROUP BY ?specialite
    } .
}}
        
                
C'est la requête pour sélectionner le niveau d'études par élève
select distinct ?annee {
?etu sides:is_enrolled_in_centreyear ?poleannee.
?poleannee sides:has_for_year_of_study ?annee.
filter (?etu = sides:etu12514)
}
                        
                        
SELECT distinct ?epreuve
WHERE {
    ?adr sides:has_for_result ?note .
    ?adr sides:done_by ?etudiant .
    ?adr sides:done_during ?epreuve .
    ?adr sides:correspond_to_a_question ?q .
    ?q sides:is_linked_to_ENC_referential_entity ?item .
    ?item sides:is_linked_to_the_medical_speciality ?specialite .
    filter (?etudiant = sides:etu12514)
}
                        

sides:epreuve37785

                                
SELECT ?specialite ?label  ((?moyennespecialite) AS ?moy) ?moyenneetu
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT ?specialite ((AVG(?note1)) AS ?moyennespecialite) ((COUNT(DISTINCT ?q1)) AS ?nbquestionspecialite)
        WHERE {
            ?adr1 sides:has_for_result ?note1 .
            ?adr1 sides:done_by ?etu .
            ?adr1 sides:done_during ?epreuve .
            ?adr1 sides:correspond_to_a_question ?q1 .
            ?q1 sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
        }
        GROUP BY ?specialite
    } .
    {
        SELECT ?specialite ((AVG(?note)) AS ?moyenneetu) ((COUNT(DISTINCT ?q)) AS ?nbquestionItemEtu)
        WHERE {
            ?adr sides:has_for_result ?note .
            ?adr sides:done_by ?etudiant .
            ?adr sides:done_during ?epreuve .
            ?adr sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
            filter (?etudiant = sides:etu12514 && ?epreuve = sides:epreuve37785)
        }
        GROUP BY ?specialite
    } .

    OPTIONAL {
        SELECT ?specialite str(?label) as ?label
        WHERE {
            ?specialite a sides:speciality.
            ?specialite rdfs:label ?label.
        }
        GROUP BY ?specialite
    } .
}}
        
                        



sides:epreuve37779

                                
SELECT ?specialite ?label  ((?moyennespecialite) AS ?moy) ?moyenneetu
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT ?specialite ((AVG(?note1)) AS ?moyennespecialite) ((COUNT(DISTINCT ?q1)) AS ?nbquestionspecialite)
        WHERE {
            ?adr1 sides:has_for_result ?note1 .
            ?adr1 sides:done_by ?etu .
            ?adr1 sides:done_during ?epreuve .
            ?adr1 sides:correspond_to_a_question ?q1 .
            ?q1 sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
        }
        GROUP BY ?specialite
    } .
    {
        SELECT ?specialite ((AVG(?note)) AS ?moyenneetu) ((COUNT(DISTINCT ?q)) AS ?nbquestionItemEtu)
        WHERE {
            ?adr sides:has_for_result ?note .
            ?adr sides:done_by ?etudiant .
            ?adr sides:done_during ?epreuve .
            ?adr sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
            filter (?etudiant = sides:etu12514 && ?epreuve = sides:epreuve37779)
        }
        GROUP BY ?specialite
    } .

    OPTIONAL {
        SELECT ?specialite str(?label) as ?label
        WHERE {
            ?specialite a sides:speciality.
            ?specialite rdfs:label ?label.
        }
        GROUP BY ?specialite
    } .
}}
        
                        



sides:epreuve37777

                                
SELECT ?specialite ?label  ((?moyennespecialite) AS ?moy) ?moyenneetu
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT ?specialite ((AVG(?note1)) AS ?moyennespecialite) ((COUNT(DISTINCT ?q1)) AS ?nbquestionspecialite)
        WHERE {
            ?adr1 sides:has_for_result ?note1 .
            ?adr1 sides:done_by ?etu .
            ?adr1 sides:done_during ?epreuve .
            ?adr1 sides:correspond_to_a_question ?q1 .
            ?q1 sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
        }
        GROUP BY ?specialite
    } .
    {
        SELECT ?specialite ((AVG(?note)) AS ?moyenneetu) ((COUNT(DISTINCT ?q)) AS ?nbquestionItemEtu)
        WHERE {
            ?adr sides:has_for_result ?note .
            ?adr sides:done_by ?etudiant .
            ?adr sides:done_during ?epreuve .
            ?adr sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
            filter (?etudiant = sides:etu12514 && ?epreuve = sides:epreuve37777)
        }
        GROUP BY ?specialite
    } .

    OPTIONAL {
        SELECT ?specialite str(?label) as ?label
        WHERE {
            ?specialite a sides:speciality.
            ?specialite rdfs:label ?label.
        }
        GROUP BY ?specialite
    } .
}}
        
                        



Spécialités non traitées par l'étudiant
sides:medical_specialty_cardiovascular
sides:medical_specialty_hematology
sides:medical_specialty_internal_medicine
sides:medical_specialty_neurology
sides:medical_specialty_anesthesiology_resuscitation_emergencies
sides:medical_specialty_gerontology
sides:medical_specialty_endocrinology_metabolism_nutrition
sides:medical_specialty_nephrology
sides:medical_specialty_pediatrics
sides:medical
sides:medical_specialty_therapeutic_pharmacology
sides:medical_specialty_public_health
sides:medical_specialty_digestive_surgery
sides:medical_specialty_hepatogastroenterology
sides:medical_specialty_cancerology_radiotherapy
sides:medical_specialty_psychiatry
sides:medical_specialty_addiction
sides:medical_specialty_forensic_medecine
sides:medical_specialty_otorhinolaryngology
sides:medical_specialty_neurosurgery
sides:medical_specialty_orthopedics
sides:medical_specialty_ophthalmology
sides:medical_specialty_maxillofacial_surgery
sides:medical_specialty_physical_medicine_and_rehabilitation
                
SELECT ?specialite
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT DISTINCT ?specialite
        WHERE {
            ?adr sides:has_for_result ?note .
            ?adr sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:is_linked_to_the_medical_speciality ?specialite .
        }
    } .
    MINUS {
        {
            SELECT DISTINCT ?specialite
            WHERE {
                ?adr sides:has_for_result ?note .
                ?adr sides:done_by ?etudiant .
                ?adr sides:correspond_to_a_question ?q .
                ?q sides:is_linked_to_ENC_referential_entity ?item .
                ?item sides:is_linked_to_the_medical_speciality ?specialite .
                filter (?etudiant = sides:etu12514)
            }
        } .
    } .
}}
        
                
Le pourcentage d'items pour lesquels l'étudiant a répondu à des questions est de 2.7439 %

                
SELECT ((xsd:float(?itemetu) / xsd:float(?itemtotal) * 100) AS ?pourcentageItemCouvertEtu)
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT ((COUNT(DISTINCT ?item)) AS ?itemtotal)
        WHERE {
            ?q sides:is_linked_to_ENC_referential_entity ?item .
        }
    } .
    {
        SELECT ((COUNT(DISTINCT ?item1)) AS ?itemetu)
        WHERE {
            ?action sides:done_by ?etudiant .
            ?action sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item1 .
            filter (?etudiant = sides:etu12514)
        }
    } .
}}
        
                
item intituleItem nbquestionItem moyenneItem nbquestionItemEtu moyenneetu
sides:item_152 Infections cutaneo-muqueuses et des phanères, bacteriennes et mycosiques de l'adulte et de l'enfant 99 0.610951008645533 15 0.56
sides:item_304 Tumeurs des os primitives et secondaires 59 0.526456310679612 15 0.32
sides:item_148 Meningites, meningoencephalites chez l'adulte et l'enfant 206 0.577927548441449 15 0.333333333333333
sides:item_142 Surveillance des maladies infectieuses transmissibles 63 0.497530864197531 16 0.3
sides:item_26 Prevention des risques foetaux 84 0.593698630136986 15 0.56
sides:item_168 Parasitoses digestives 63 0.643682310469314 15 0.56
sides:item_165 Infections à VIH 138 0.554545454545455 14 0.507142857142857
sides:item_306 Tumeurs du poumon, primitives et secondaires 154 0.55583543240974 12 0.383333333333333
sides:item_155 Tuberculose de l'adulte et de l'enfant 89 0.525925925925926 16 0.3
                
SELECT ?item str(?intituleItem) as ?intituleItem ?nbquestionItem ((?moyennenoteetu) AS ?moyenneItem) ?nbquestionItemEtu ?moyenneetu
WHERE {GRAPH <http://ontosides.en> {
    {
        SELECT ?item ((AVG(?note1)) AS ?moyennenoteetu) ((COUNT(DISTINCT ?q1)) AS ?nbquestionItem)
        WHERE {
            ?adr1 sides:has_for_result ?note1 .
            ?adr1 sides:done_by ?etu .
            ?adr1 sides:correspond_to_a_question ?q1 .
            ?q1 sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:has_for_title ?intituleItem .
        }
        GROUP BY ?item
    } .
    {
        SELECT ?item ((AVG(?note)) AS ?moyenneetu) ((COUNT(DISTINCT ?q)) AS ?nbquestionItemEtu)
        WHERE {
            ?adr sides:has_for_result ?note .
            ?adr sides:done_by ?etudiant .
            ?adr sides:correspond_to_a_question ?q .
            ?q sides:is_linked_to_ENC_referential_entity ?item .
            ?item sides:has_for_title ?intituleItem .
            filter (?etudiant = sides:etu12514)
        }
        GROUP BY ?item
    } .
    {
        SELECT ?item ?intituleItem
        WHERE {
            ?item sides:has_for_title ?intituleItem .
        }
    } .
}}