Could you see the problem? There were many rows with the same year, so each year is shown many times in the results.
In our orders example, if there were many orders placed by the same customer, each customer ID would be shown many times in the results. Not good.
Fortunately, we can easily change this.
SELECT DISTINCT customer_id FROM orders;
Before the column name, we've added the word DISTINCT. Now the database will remove duplicates and only show distinct values. Each customer_id will appear only once.
Select the column year from the employees table in such a way that each year is only shown once.
Type:
SELECT DISTINCT year FROM employees;
