Fill in the Blank {5 pts each, Total: 10 pts ) is a query (SELECT statement) inside another query is used to generate unique numeric values that #2. An Oracle can be used to create surrogate keys Short Answer { 10 pts each, Total: 40 pts j For all of these questions, you are writing the SQL command, not showing the results Use these tables for all of the Short Answer questions: Database name: Ch08 SaleCo Table name: CUSTOMER Table name: INVOICE INV NUM | CUST NUM? INV DATE | INV AMOUNT 235.89 312.82 528.10 194.78 619.44 CUST-NUM | CUST,LNAME | CUSTFNAME | CUST BALANCE 1050.11 84092 8000 001 8002 000 23-Mar-10 1001 23-Mar-10 1001 30-Mar-10 1000 12-Apr-10 1000 Smith 1001 Ortega Jeanne Juan 000 23-Apr10 Table name: CUSTOMER 2 8004 CUST CUST CUST FNAME 2000 McPheson Anne 2001 Ortega 2002 Kowalski 2003 Chern Juan Jan George #1. Write a query to show the invoice number, the invoice date. customer number and customer last name for all customers who have a customer balance of more than $1,000