[Solved] How do I write this query in SQL? [closed]

You can do self join.

SELECT A.Artist
    FROM 
    Album A
    INNER JOIN Album B ON A.Artist=B.Artist AND A.Year=B.Year
    WHERE A.Type="LIVE" AND B.Type="STUDIO"

Hope this helps.