请教一个复杂的sql问题

[修炼成精]

表[news_sort]包含字段[sortid]、[title]、[parentid]等
表[news_QasUnit]包含[QasID]、[ProductID]、[QasUnit]等（其中news_QasUnit.ProductID=news_sort.sortid）
表[news_Price]包含[ID] [int] IDENTITY(1,1) NOT NULL,
[Price] [money] NULL,
[Createdate] [datetime] NULL,
[CenterFlag] [int] NULL CONSTRAINT [DF_news_Price_CenterFlag] DEFAULT ((1)),
[Bak] [nvarchar](1000) NULL,
[QasID] [int] NULL,
[RunCircs] [varchar](50) NULL,
[Count] [int] NULL,
[Repertory] [varchar](50) NULL,
如何得到parentid=4时的所有价格，要求价格按news_sort.title分组

[寻找Python之禅]

select price
from news_price
where news_price.qasid in (select qasid 
                           from news_qasunit
                           where productid in (select sortid
                                               from news_sort
                                               where parentid=4))

[等待戈多12]

select a.price,b.title from news_price a,news_sort b
where b.parentid=4 and b.sortid=news_qasunit.productID
and a.qasID=new_qasunit.qasID
group by b.title

[-狙击手-]

select a.title,c.price
from new_sort a
left join new_aqsunit b on b.prodectid = a.sortid
left join news_price c on b.qasid = c.qasid
where a.parentid = 4
order by 1,2