In the query, which functions should you use for ChargedQuantity and OrderPrice?

In the query, which functions should you use for ChargedQuantity and OrderPrice?

• A. CHOOSE and COALESCE
• B. COALESCE and LEAST
• C. IIF and COALESCE
• D. CHOOSE and LEAST

Answer: (B)

Handling missing data and enforcing value bounds are the ideas here. For ChargedQuantity, you want to guarantee a defined number even when the source is NULL, so COALESCE is the right tool. Using COALESCE(ChargedQuantity, 0) replaces any NULL with a sensible default (0), ensuring your calculations don’t propagate NULLs and cause errors or unexpected results. For OrderPrice, you often need to keep prices within a permitted range. LEAST helps by always choosing the smaller of two values, which is great for clamping a price to a maximum. For example, LEAST(calculatedPrice, maxAllowed) ensures you don’t exceed the allowable price, regardless of how the price was derived. Other options aren’t as well suited to these tasks. CHOOSE isn’t about null handling, and while IIF can implement conditional logic, COALESCE is simpler and more robust for NULLs, leaving LEAST to handle the cap.

Handling missing data and enforcing value bounds are the ideas here. For ChargedQuantity, you want to guarantee a defined number even when the source is NULL, so COALESCE is the right tool. Using COALESCE(ChargedQuantity, 0) replaces any NULL with a sensible default (0), ensuring your calculations don’t propagate NULLs and cause errors or unexpected results.

For OrderPrice, you often need to keep prices within a permitted range. LEAST helps by always choosing the smaller of two values, which is great for clamping a price to a maximum. For example, LEAST(calculatedPrice, maxAllowed) ensures you don’t exceed the allowable price, regardless of how the price was derived.

Other options aren’t as well suited to these tasks. CHOOSE isn’t about null handling, and while IIF can implement conditional logic, COALESCE is simpler and more robust for NULLs, leaving LEAST to handle the cap.