who is the lyricist that wrote happiness is a warm gun with another lyricist who also wrote (just like) starting over?
Entity Entity
m.03j24kf m.07r4c
Paul McCartney Tori Amos
class entity class entity
music.lyricist m.0bb7nj4 music.lyricist m.04nfdz
music.lyricist music.arrangement music.lyricist tv.tv_theme_song
Lyricist Happiness Is a Warm Gun Lyricist (Just Like) Starting Over
none none none none
music.lyricist.lyrics_written music.composition.lyricist music.composition.lyricist
Lyrics Written Lyricist Lyricist
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (?x0 AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :music.lyricist . 
VALUES ?x1 { :m.0bb7nj4 } 
?x2 :type.object.type :music.lyricist . 
VALUES ?x3 { :m.04nfdz } 
?x0 :music.lyricist.lyrics_written ?x1 . 
?x1 :music.composition.lyricist ?x2 . 
?x3 :music.composition.lyricist ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x0 != ?x3 && ?x1 != ?x2 && ?x1 != ?x3 && ?x2 != ?x3  )
}
}
(AND music.lyricist (JOIN music.lyricist.lyrics_written m.0bb7nj4))