组合SQL行，其中列X值相等但列Y值不同（需要重写）

complete newbie in SQL here. I have an assignment where I was supposed to create a whole bunch of tables and then perform certain filtering among them. As seen from the picture, these are actually 2 distinct titles (from a larger table that has more of these) but each of them comes as a book, audio and video copy, hence why there are 3 rows for each distinct title. complete newbie in SQL here. I have an assignme