Being from the US, I’d say a gourd is any “hollow” squash, especially one you don’t normally eat in its normal form. So a pumpkin is both a gourd and a squash. Butternut squash is probably a gourd but definitely not a pumpkin. Zucchini is neither a gourd nor a pumpkin, but is decidedly a squash.