Konular
Anasayfa
/
Teknoloji
/
Q2.2 Select UPPER(Name), INSTR (Speciality, "d") AS "contains D. LENGTH(Speciality) AS "Speciality Length" FROM Doctors Where SUBSTR

Soru

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";

Çözüm

4.4 (185 Oylar)
Rengin
Uzman doğrulaması
Uzman · 3 yıl öğretmeni

Cevap

The correct answer is:UPPER(Name), INSTR (Speciality, "d") AS "contains d", LENGTH(Speciality) AS "Speciality Length"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".