In the pic below

6- The SQL like operator is case sensitive, but the lower() function on strings can be used to perform case insensitive match 6- The SQL like operator is case sensitive, but the lower() function on strings can be used to perform case insensitive matching. Write a query that finds instructors whos names contain the string “ric” instructor ID name depl_name salary 76766 Crick Bic Biology 82000 76766 Crick Biology 72000 45565 Katz | Comp. Sci. 75000 10101 Srinivasan Comp. Sci. 65000 83821 Brandt Comp. Sci. 92000 98345 Kim | Elec. Eng. | 80000 12121 Wu Finance 90000 76543 Singh Finance 80000 32343 El Said 95000 58583 Califieri History 62000 15151 Mozart Music 40000 33456 Gold Physics 87000 22222 Einstein Physics 95000 History



Source link

Leave a Reply

Your email address will not be published.