Ultimate access to all questions.
You are working as a Fabric Analytics Engineer and are tasked with optimizing a SQL query for a dataset containing product sales information. The dataset includes columns for product ID, product name, and units sold. Your goal is to retrieve the product name and the total number of units sold for each product, excluding products with zero sales, while ensuring the query is efficient and scalable for large datasets. Which of the following SQL queries best meets these requirements? (Choose one option)