-- View Data Table
SELECT
	*
FROM
	[dbo].[Data$];

-- View Sample information Table
SELECT
	*
FROM
	[dbo].[SampleInformation$];

--Join Data and Sample information Table
SELECT
	dt.*,
	SI.*
FROM
	[dbo].[Data$] AS dt
	JOIN [dbo].[SampleInformation$] AS SI
	ON dt.ID = SI.ID;

--Summarize Your Data
SELECT
	[Group],
	[Sex],
	AVG([Body Weight]) AS avg_weight,
	STDEV([Body Weight]) AS SD_weight,
	STDEV([Body Weight])/SQRT(COUNT(DISTINCT dt.ID)) AS SE_weight,
	AVG(Height) AS avg_height,
	STDEV(Height) AS SD_height,
	AVG([% Body Fat]) AS avg_body_fat,
	STDEV([% Body Fat]) AS SD_body_fat,
	COUNT(DISTINCT dt.ID) AS n
FROM
	[dbo].[Data$] AS dt
	JOIN [dbo].[SampleInformation$] AS SI
	ON dt.ID = SI.ID
WHERE
	dt.ID >= 200
GROUP BY
	[GROUP],
	[Sex]
ORDER BY
	[GROUP] DESC,
	[Sex];

--Filter and Sort your Summarized Data
SELECT
	[Group],
	[Sex],
	AVG([Body Weight]) AS avg_weight,
	STDEV([Body Weight]) AS SD_weight,
	STDEV([Body Weight])/SQRT(COUNT(DISTINCT dt.ID)) AS SE_weight,
	AVG(Height) AS avg_height,
	STDEV(Height) AS SD_height,
	AVG([% Body Fat]) AS avg_body_fat,
	STDEV([% Body Fat]) AS SD_body_fat,
	COUNT(DISTINCT dt.ID) AS n
FROM
	[dbo].[Data$] AS dt
	JOIN [dbo].[SampleInformation$] AS SI
	ON dt.ID = SI.ID
WHERE
	dt.ID >= 200
GROUP BY
	[GROUP],
	[Sex]
ORDER BY
	[GROUP] DESC,
	[Sex];