Union Junction Operator

Question

I need to present the departments that had stock movement in Feb/2018 and those that had in Mar/2018. I need to use a union operator to show the results of the two queries each of them returning the one-month departments. In each query I should avoid repeated departments. I need to show the code and name of the department by ordering by the code of the same. This table below is the stock movement table (MOVESTOQUE)

My department table (DEPARTMENT) is this: CODDEP 1, 2, 3, 4, 5, 6, 7, 8, 9 DESCRIPTION Sales (1), Purchases(2), IT(3), Management(4), Warehouse(5), Directorate(6), Financial(7), Stock(8), Customer Service(9))

CODDEP is a column and DESCRICAO is another column.

Answer 1

select distinct
coddep,
dthora

from
movestoque

where
dthora between '2018-02-01' and '2018-02-28'

UNION

select distinct
coddep,
dthora

from
movestoque

where
dthora between '2018-03-01' and '2018-03-31'