How does the computer perceive when we don't put/do put column name in front of OR

HI everyone,

I know I got different results from below two different sets. But I don’t really understand how exactly the computer perceives these two sets differently.

  1. the correct one, which shows the medium that is only silver or only gold and silver/gold & others
    SELECT *
    WHERE medium LIKE ‘%gold%’
    OR medium LIKE ‘%silver%’
    FROM met;

  2. the wrong one, which shows the medium that is silver/gold and others
    SELECT *
    WHERE medium LIKE ‘%gold%’ OR ‘%silver%’
    FROM met;

link to OR course: https://www.codecademy.com/paths/data-science/tracks/sql-basics/modules/dspath-sql-queries/lessons/queries/exercises/or