Examine the description of the CUSTOMERS table:
You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two WHERE conditions give the required result?
To display the last names and credit limits of all customers whose last name starts with A or B (in either lower or upper case), and whose credit limit is below 1000, we need to ensure the WHERE conditions meet these specific criteria. The correct conditions should convert the last names to a uniform case for comparison and directly check if the credit limit is below 1000 without altering its value unnecessarily. Option B uses UPPER to convert the last names to upper case and checks for patterns starting with A or B, correctly filtering credit limits below 1000. Option D employs INITCAP for capitalization and direct comparison of credit limits, though INITCAP might not be necessary. Both options meet the requirements appropriately: converting the case for comparison and correctly checking credit limits.
BD tested
BD is correct
BD must be right
For option B, what if cust_credit_limit = 999.6?
B D are correct
only D, B not in case cust_credit_limit =1000.45
BD is correct
BD is the correct answer
What is the point of using round?
BD correct, since E didnt not search for the last name start with A/B, the condition is looking for lastname='A'