Given the Table CUSTOMER(CustID,Name,PhoneNum,AcctBalance)

question 57

Multiple Choice

Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

• A) WHERE CUSTOMER-AcctBalance > 50
• B) WHERE (CUSTOMER-AcctBalance > 50)
• C) WHERE AcctBalance > 50
• D) WHERE (AcctBalance > 50)
• E) HAVING AcctBalance > 50

---

Definitions:

Cost Control

The practice of managing and reducing business expenses to increase profitability.

Management Accounting

The process of preparing management reports and accounts that provide accurate and timely financial and statistical information necessary for managers to make day-to-day and short-term decisions.

Cost Accounting

A branch of accounting focused on calculating and controlling costs of producing or providing services.

Competitive Environment

The external factors and forces that affect an organization's ability to compete in its market, including competitors, market trends, and regulatory conditions.