[Solved] What is wrong with this dbt model SQL? WITH data AS ( SELECT user_id, COUNT(*) AS order_count FROM orders GROUP BY user_id ) SELECT user_id, order_count FROM data WHERE order_count > '5' | dbt

dbt - Advanced Patterns

What is wrong with this dbt model SQL?

WITH data AS (
  SELECT user_id, COUNT(*) AS order_count FROM orders GROUP BY user_id
)
SELECT user_id, order_count FROM data WHERE order_count > '5'

AComparing integer order_count to string '5' causes type mismatch

BMissing alias for COUNT(*)

CGROUP BY should include order_count

DCTE cannot be named 'data'

Step-by-Step Solution

Solution:

Step 1: Check the WHERE clause condition
order_count is numeric but compared to string '5'.
Step 2: Understand type comparison rules
Comparing integer to string can cause errors or unexpected results.
Final Answer:
Comparing integer order_count to string '5' causes type mismatch -> Option A
Quick Check:
Numeric vs string comparison causes errors [OK]

Quick Trick: Compare numbers to numbers, not strings [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

What is wrong with this dbt model SQL?