Question: Write the query that lists the average age of your customers. (Assume that the CUSTOMER table has been modified to include the CUST_DOB and the

Write the query that lists the average age of your customers. (Assume that the CUSTOMER table has been modified to include the CUST_DOB and the derived CUST_AGE attribute.)Write the query that lists the average age of your customers. (Assume

FIGURE P8.1 CH08 SIMPLECO DATABASE TABLES Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST FNAME CUST BALANCE INV NUM | CUST NUM? INV DATE INV AMOUNT 235.89 312.82 528.10 194.78 619.44 1000 Smith 1001 Ortega Jeanne Juan 050.11 840.92 8000 1000 23-Mar-16 1001 23-Mar-16 1001 30-Mar-16 1000 12-Apr-16 1000 23-Apr-16 8003 8004 Table name: CUSTOMER 2 CUST NUM | CUST LNAME CUST FNAME 2000 McPherson 2001 Ortega 2002 Kowalski 2003 Chen Anne Juan Jan George

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!