26zp1FXD

1CREATE TABLE IF NOT EXISTS sugestoes (
2    id     INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
3    texto  VARCHAR(250),
4    autor  VARCHAR(250),
5    itens  VARCHAR(250),
6    pontos INTEGER
7);
8	
9CREATE TABLE IF NOT EXISTS vertices (
10    id            INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
11    id_node_pai   INTEGER,
12    id_node_filho INTEGER,
13    FOREIGN KEY (id_node_pai)   REFERENCES sugestoes(id),
14    FOREIGN KEY (id_node_filho) REFERENCES sugestoes(id)
15);
16	
17SELECT DISTINCT s.autor
18FROM sugestoes AS s
19LEFT JOIN vertices AS v
20WHERE s.id <> v.id_node_pai;