****************************************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Record Sorting new3.rpt
****************************************************************************************************

-------------------------------------------------- Main Body --------------------------------------------------

-- Query(s)

SELECT 
	Customer.[Customer Name]
	,Customer.[Last Year's Sales]
	,Customer.Region
	,Customer.Country
	,Customer.[Last Year's Sales]
FROM
	Customer
WHERE
	Customer.Country in ("Belgium", "Germany", "France", "England", "Canada", "Mexico", "USA")
ORDER BY
	Customer.Country ASC -- Group #1
	,Customer.Region ASC 
	,Customer.[Last Year's Sales] DESC