Запрос (БД книжный магазин)

select b.Pages, b.[ID _ THEME] from dbo.[BOOKS (book)].b, dbo.[Themes (book)],
CONVERT (char(10),Sum(b.Pages*b.[ID _ THEME])) as 'average_pages',b.ID_THEME

SELECT t.NameTheme, sum(b.Pages) as 'pages count by theme'
from [BOOKS (book)] b, [Themes (book)] t
where t.[ID _ THEME]=b.[ID _ THEME]
group by t.NameTheme

SELECT t.NameTheme, 
b.Pages,
sum(b.Pages) as 'pages count by theme'
from [BOOKS (book)] b, [Themes (book)] t
where b.[ID _ THEME]=t.[ID _ THEME] and t.NameTheme in ('біографія','СУБД.Бази даних','програмування') 
group by t.NameTheme,
b.Pages
having b.Pages>300

select (s.Quantity)
from [Authors (book)] a, [BOOKS (book)] b,[SALES (sale)] s, [Shops (sale)] sh, [Country (global)*] c
where sh.ID_SHOP=s.ID_SHOP and
s.Quantity > all (select s.Quantity
from [Authors (book)] a, [BOOKS (book)] b,[SALES (sale)]s,[Shops (sale)]sh, [Country (global)*] c
where b.ID_AUTHOR=a.ID_AUTHOR and a.ID_COUNTRY = c.ID_COUNTRY and c.NameCountry= 'CША')
group by s.Quantity
--order by 1 desc;