SELECT 
    [Materials].[Material_Type_ID] AS 'Тип сырья', 
    [Materials].[Measurement_ID] AS 'Ед. измер-я',   
    [Materials].[Material] AS 'Сырье', 
    [Materials].[Material_Price] AS 'Цена' 

FROM [dbo].[Materials] 

ORDER BY 
    [Materials].[Material_Type_ID], 
    [Materials].[Measurement_ID],   
    [Materials].[Material]
    
SELECT 
	MAX(Materials.Material_Price) AS 'Макс. цена',
	AVG(Materials.Material_Price) AS 'Сред. цена'

FROM [dbo].[Materials] 

GROUP BY [Materials].[Material_Type_ID]

SELECT 
	[Storage].[КодСырья], 
	SUM([Storage].[Цена] * [Storage].[Количество]) N'Общ. объем сырья'

FROM dbo.Storage

WHERE 
	[Storage].[КодСклада] = 1 AND 
	YEAR([Storage].[Датадвижения]) LIKE '2002'

GROUP BY [Storage].[КодСырья]
ORDER BY [Storage].[КодСырья]

SELECT 
	[Materials].[Material],
	[Storage].[Количество],
	[Stores].[Store]

FROM
	[dbo].[Materials_Types] LEFT JOIN
	[dbo].[Materials] ON [Materials_Types].[ID] = [Materials].[Material_Type_ID] LEFT JOIN
	[dbo].[Storage] ON [Materials].[ID] = [Storage].[КодСырья] LEFT JOIN
	[dbo].[Stores] ON [Storage].[КодСкладаДвиж] = [Stores].[ID]

WHERE
	[Materials_Types].[ID] = 9 AND
	(DATEPART (YEAR, [Storage].[Датадвижения]) BETWEEN '2003' AND '2004') AND
	--([Storage].[Датадвижения] >= '2003-01-01' AND [Storage].[Датадвижения] < '2004-01-01') AND
	--([Storage].[Датадвижения] BETWEEN '2003-01-01' AND '2004-01-01') AND
	(DATEPART (ISO_WEEK, [Storage].[Датадвижения]) % 2 = 0)

GROUP BY
	[Materials].[Material],
	[Storage].[Количество],
	[Stores].[Store]

ORDER BY 
	[Storage].[Количество]