The Doc_name Column of a table Hospital is given below :

Doc_name
Avinash
Hariharan
Vinayak
Deepak
Sanjeev

Based on the information, find the output of the following queries :

(i) SELECT docname FROM HOSPITAL WHERE Docname like "%v";

(ii) SELECT docname FROM HOSPITAL WHERE docname like "%e%";

(i) SELECT doc_name FROM HOSPITAL WHERE Doc_name like "%v";

+----------+
| doc_name |
+----------+
| Sanjeev  |
+----------+

Working

The query SELECT doc_name FROM HOSPITAL WHERE Doc_name like "%v"; selects the doc_name from the HOSPITAL table where the Doc_name column ends with the letter "v" using the LIKE operator with the "%" wildcard. This pattern matches any string where "v" is the last character, and any characters can precede it.

(ii) SELECT doc_name FROM HOSPITAL WHERE doc_name like "%e%";

+----------+
| doc_name |
+----------+
| Deepak   |
| Sanjeev  |
+----------+

Working

The query SELECT doc_name FROM HOSPITAL WHERE doc_name like "%e%"; selects the doc_name from the HOSPITAL table where the doc_name column contains the letter "e". This is achieved using the LIKE operator with the "%" wildcard before and after the letter "e", which matches any sequence of characters that have "e" in them.