Total Number Of Some Column

SELECT COUNT(SomeColumnName) FROM SomeTable WHERE ...
SELECT SomeColumnName, COUNT(SomeColumnName) FROM SomeTable WHERE ... GROUP BY SomeColumnName

	//You can read it like this
	TotalVideosInSection = Convert::ToInt32(Row[0]);

Total Number Of Rows

SELECT COUNT(*) FROM SomeTable WHERE ...

Sum Of Some Column

SELECT SUM(SomeColumnName) FROM SomeTable WHERE ...

Total Number Of True

SELECT SUM(CONVERT(int, SomeBoolColumnName)) FROM SomeTable

Total Number Of False

SELECT COUNT(SomeBoolColumnName)-SUM(CONVERT(int, SomeBoolColumnName)) FROM SomeTable

Grouping Results

Use GROUP BY