Q2.2 Select UPPER(Name), INSTR (Speciality, "d") AS "contains d. LENGTH(Speciality) AS "Speciality Length" FROM Doctors Where SUBSTR (speciality length(speciality) -, length(speciality))="gist";

The correct answer is:<br /><br />UPPER(Name), INSTR (Speciality, "d") AS "contains d", LENGTH(Speciality) AS "Speciality Length"<br /><br />Explanation: The query is selecting the uppercased name of the doctors, the position of the letter "d" in their specialty, and the length of their specialty. The WHERE clause is filtering the results to only include doctors whose specialty ends with "gist".