Iris, a consumer electronics brand, would like to modify a query to only include purchase records from the underlying table. Which of the following represents how the query should be written?

The correct query filters the amazonattributedeventsbytraffictime table using WHERE purchases = 1. This condition specifically selects records where a purchase occurred, fulfilling the requirement to include only purchase records. The GROUP BY 1 aggregates the results by campaign, and COUNT(DISTINCT userid) and SUM(purchases) calculate the number of unique purchasers and total purchases for each campaign, respectively. The second incorrect option uses FROM conversions, which is a different table and may not contain the necessary purchases column or the desired data structure. The third incorrect option uses FROM amazonattributedeventsbytraffictime but lacks the WHERE purchases = 1 clause, meaning it would include all records from the table, not just purchase records.