SQL query with possible duplicate records

You must execute the code again to save those values in the database.

-- INIT database
CREATE TABLE snippets (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  attrs TEXT NOT NULL,
  template_id INTEGER,
  location_id INTEGER
);

INSERT INTO snippets (name, attrs, template_id) VALUES ('Age', json('{"age": 42}'), 1);
INSERT INTO snippets (name, attrs, template_id) VALUES ('Name', json('{"name": "foo"}'), 1);
INSERT INTO snippets (name, attrs, template_id) VALUES ('Age', json('{"age": 33}'), 2);
INSERT INTO snippets (name, attrs, template_id) VALUES ('Name', json('{"name": "jon"}'), 2);
INSERT INTO snippets (name, attrs, template_id) VALUES ('Age', json('{"age": 42}'), 3);
INSERT INTO snippets (name, attrs, template_id) VALUES ('Name', json('{"name": "foo"}'), 3);

INSERT INTO snippets (name, attrs, location_id) VALUES ('Name', json('{"name": "bar"}'), 1);
INSERT INTO snippets (name, attrs, location_id) VALUES ('Name', json('{"name": "bar"}'), 2);

WITH t AS (
  SELECT 
    id,
    name,
    attrs,
    template_id,
    location_id,
    ROW_NUMBER() OVER w AS x
  FROM snippets
  where template_id = 2 or location_id = 3
  WINDOW w AS (
    PARTITION BY Name 
    ORDER BY location_id IS NULL
  )
)
SELECT * 
FROM t 
WHERE x = 1

-- Expected result:
-- id	name	attrs			template_id		location_id
-- --------------------------------------------------------------------------------------------------------------------
-- 1	Age		{"age":42}		1				null
-- 3	Name	{"name":"bar"}	null			1			-> since this record is mor concrete that the one with ID 2

id	name	attrs	template_id	location_id	x
3	Age	{"age":33}	2		1
4	Name	{"name":"jon"}	2		1