SQL data base this is a request to table from my data base


Hello I need some help,

select Designacao
from tb_Jogos
where year (data_Lancamento) >= 2018
or year (data_Lancamento) <= 2017
or year (data_Lancamento) <= 2012

this is to select dates from my table from a database, I have this, but it’s not complete , need to give names to that dates like: ‘Old’, ‘New’ and ‘Moment’ and I cant’t find how?

help please :wink: