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.)
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
Get step-by-step solutions from verified subject matter experts
