Question 1easymultiple choice
Read the full Data Querying And Analysis explanation →DS0-001 Data Querying And Analysis • Complete Question Bank
Complete DS0-001 Data Querying And Analysis question bank — all 0 questions with answers and detailed explanations.
A junior data analyst runs the following query against a retail sales table and receives 42,000 rows instead of the expected 12,000:
SELECT c.customer_id, c.customer_name, o.order_id FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id WHERE o.order_status <> 'cancelled';
Which action should the analyst take to return all customers, including those with no orders, while still excluding cancelled orders?