Find the average, highest, and lowest age for students.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT AVG((SYSDATE - BirthDate)/365),
2 MAX((SYSDATE - BirthDate)/365),MIN((SYSDATE - BirthDate)/365
3 FROM student;
AVG((SYSDATE-BIRTHDATE)/365) MAX((SYSDATE-BIRTHDATE)/365)
---------------------------- ----------------------------
MIN((SYSDATE-BIRTHDATE)/365)
----------------------------
22.077602 33.7008897
18.5447253
```
You might also like to view...
Which of the following are advantages of optical communication links? (Select three.)
a. Extremely wide bandwidth b. Elimination of crosstalk c. Elimination of attenuation d. Security
To associate an external style sheet with a web page, code:
a. a link element in the body section of the web page b. a link element in the head section of the web page c. a style element in the body section of the web page d. a style element in the head section of the web page
In a(n) __________ relationship, a class object has references to objects of other classes as members.
Fill in the blank(s) with the appropriate word(s).
Answer the following statements true (T) or false (F)
1. When you call the setf function on an output stream, the effect is only until the next output. 2. Setting the width of output with call to the width member function, affects only the next output. 3. Setting the width of output with the manipulator setw is different from setting the width with the width member function. 4. If the output is too wide for the width specified in a setw manipulator or a call to the width member function, then the output is lost.