Chapter 3, Problem 6PE

Explanation of Solution

LIKE operator:

“LIKE” operator is used to get set of values which matches the set of characters. The “LIKE” operator uses “%” sign and it uses underscore (_) which is used to represent the characters.

Syntax:

SELECT * FROM table_Name WHERE column_Name LIKE pattern;

“LOWER” keyword:

The keyword “LOWER” is used to convert the string into small letters that is, it converts the string into lower case letters...