How do we avoid getting duplicate values in query results?

With the DISTINCT keywordWith two WHERE filters

With the DISTINCT keyword.