Structure of the CUSTOMERS Table

question 32

Multiple Choice

Structure of the CUSTOMERS table

-Which of the following queries will display the first and last name of the individual who referred another customer, along with the customer# of the referred customer?

• A) SELECT r.firstname, r.lastname, c.customer# FROM customers r, customers c WHERE r.customer# = c.referred;
• B) SELECT r.firstname, r.lastname, c.customer# FROM customers r JOIN customers c ON r.customer# = c.referred;
• C) SELECT r.firstname, r.lastname, c.customer# FROM customers r NATURAL JOIN customers c;
• D) both a and b

---

Definitions:

Installment Sales Method

An accounting method used to recognize revenue from sales where payment is received in installments over a period.

IFRS

International Financial Reporting Standards, a set of accounting standards developed by the International Accounting Standards Board (IASB) aimed at making global financial reporting more transparent and comparable.

Realized Gross Profit

The portion of profit that has been earned from completed sales transactions, excluding unrealized profits from continuing transactions.

Bundled Sales Transactions

sales deals that involve multiple products or services sold together at a combined price, potentially affecting revenue recognition and reporting.