Given the following file of renters:
| Record |
|
Apartment |
|
Lease |
| Number |
Last Name |
Number |
Rent |
Expires |
| 41 |
Warkentin |
102 |
3-Jul |
4/30 |
| 42 |
Buffington |
204 |
22-Aug |
4/30 |
| 43 |
Schuldt |
103 |
3-Jul |
4/30 |
| 44 |
Tang |
209 |
600 |
5/31 |
| 45 |
Cho |
203 |
550 |
5/31 |
| 46 |
Yoo |
203 |
550 |
6/30 |
| 47 |
Pyle |
101 |
500 |
6/30 |
a. Show an example of projection.
b. Show an example of selection.
c. Show two different examples of sorting rows.
d. Show an example of calculating totals