Hello. I am new on here and I am needing some help with this SUM and CASE WHEN. Probably easy but been trying for a while and cant seem to get it working how I want. Here is an example.

select

order number,

case when item description like X

then 2 else 1 end as adj case count,

adj case count (multiplied by) order qty = total case

sum (total case)

from -----

group by (order number....)

both the item description and order quantity are fields in the table but do not care too much about the data. Just need to see the order number matched up with the total case. Hope that makes sense and any help would be appreciated!