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
```

Computer Science & Information Technology

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

Computer Science & Information Technology

_____ 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

Computer Science & Information Technology