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...
In the HLOOKUP function, the third argument is the column index number
Indicate whether the statement is true or false
_____ There is no reason to consider the operating system of the web server when selecting a Web host
Indicate whether the statement is true or false