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...
Consider the Web site for your college department. Not all of the users who visit the site have the same reasons that you do. Identify different groups of users who might come to the site. Hint: there are at least six different groups.
What will be an ideal response?
Give full details of a mechanism for concurrency control that can be used to ensure the types of problems discussed in Question 22.3 cannot occur. Show how the mechanism prevents the problems illustrated from occurring. Discuss how the concurrency control mechanism interacts with the transaction mechanism.
What will be an ideal response?
Mens rea:
a. Refers to a mental state, often an element of the offense, which expresses the intent necessary for a particular act to constitute a crime. b. Refers to the physical act of the criminal activity, which generally includes a voluntary act which causes social harm. c. Is generally defined as an act committed, or omitted in violation of a public law.
In military time, 15:00 is ________ in non-military time.
What will be an ideal response?