Find students who started in year 2003. Use start term column and wild card.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT StudentId, Last, First, StartTerm
2 FROM student
3 WHERE StartTerm LIKE '%03';
STUDE LAST FIRST STAR
----- --------------- --------------- ----
00100 Diaz Jose WN03
00101 Tyler Mickey SP03
00102 Patel Rajesh WN03
00104 Lee Brian WN03
00105 Khan Amir WN03
```
You might also like to view...
To find the smallest and largest element of a Collection, use Collections methods _________ and __________.
a. least, greatest. b. smallest, largest. c. first, last. d. min, max.
What is the scope of the variable pencil on line 8?
``` ``` a.global b. local c. value d. reference
Which of the following choices is not one of the four types of packets used by EAP?
A. Request B. Response C. Success D. Error
Case Based Critical ThinkingCase 1You are in the process of gathering images for a website you are creating. Answer the following questions about using images on the website. Which of the following type of images can be used on your website free and without restriction?
A. Stock photos B. Clip art images C. Public domain D. Images already published on the web