Count the number of students with a “v” in their last name. Use INSTR to produce the answer. (16)
What will be an ideal response?
```
SELECT COUNT(*) "Count of V’s"
FROM student
WHERE INSTR(LOWER(last_name),'v') > 0
```
Computer Science & Information Technology
You might also like to view...
In the Windows 10 CLI, which command will create a subdirectory?
A. TREE B. MD C. CD D. DIR
Computer Science & Information Technology
Referring to the accompanying figure, which icon should you right-click to see your computer's available storage space?
A. 
B. 
C. 
D. 
Computer Science & Information Technology
In vi command mode, to delete 3 characters starting from the cursor position you type
a: xxx b: 3x c: d3 d: 3dd e: XXX
Computer Science & Information Technology
How can a method send a primitive value back to the caller?
A. It cannot send primitive values back to the caller B. By using the return statement C. By assigning the value to one of its parameters D. It can call its caller with the value
Computer Science & Information Technology