Write a SQL query to find the names and surnames of all doctors who prescribed the medication with CodeSS: MEBENDAZOL224.

To find doctors who prescribed a specific medication, we need information from the DOCTOR, CONSULTATION, and PRESCRIPTION tables. The PRESCRIPTION table links CONSULTATION (and thus DOCTOR) to MEDICATION via CodeSS.

We will join DOCTOR with CONSULTATION using Matricle, and CONSULTATION with PRESCRIPTION using ConsulNo.

We will filter the results where CodeSS in the PRESCRIPTION table matches 'MEBENDAZOL224'.

To avoid listing the same doctor multiple times if they prescribed the medication more than once, we use DISTINCT.

7. The SQL query to list all the doctors who prescribed the medication with codeSS: MEBENDAZOL224 is:

SELECT DISTINCT D.Name, D.Surname
FROM DOCTOR D
JOIN CONSULTATION C ON D.Matricle = C.Matricle
JOIN PRESCRIPTION P ON C.ConsulNo = P.ConsulNo
WHERE P.CodeSS = 'MEBENDAZOL224';