Fill in the Blank {5 pts each, Total: 10 pts ) is a query (SELECT statement) ins

Question

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.

Explanation / Answer

Question 1
Answer:
subquery

Question 2
Answer:
sequence

Question 3
Answer:

select i.inv_num, i.inv_date, c.cust_num,c.cust_lname from customer c, invoice i where c.cust_num = i.cust_num and c.cust_balance > 1000;

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.