This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Analyst at PayPal. The charges table stores all monetary amounts in cents (e.g., 13443 represents $134.43). The business intelligence team needs a cleaned dataset where amounts are expressed in dollars for dashboarding and reporting. Additionally, the captured_amount_cents column may contain null values for charges that were never captured. These nulls should be treated as zero before conversion.
You are a Data Analyst at PayPal. The charges table stores all monetary amounts in cents (e.g., 13443 represents $134.43). The business intelligence team needs a cleaned dataset where amounts are expressed in dollars for dashboarding and reporting. Additionally, the captured_amount_cents column may contain null values for charges that were never captured. These nulls should be treated as zero before conversion.