Level 7 - ArchitectOutput Prediction Questionsm2 query shape optimization

Output: COUNT(*) After INNER JOIN with Missing Matches

customers has 100 rows. orders has 40 rows, all mapped to 30 unique customers. What does INNER JOIN customer-order COUNT(DISTINCT customer_id) return?

Practice This Question Live More Output Prediction Questions