New DB
SELECT top 40 * from ps_top_of_the_props WHERE [month]=DatePart(month, dateadd(month,-1, getdate())) AND [year]=DatePart(year, dateadd(year, 0, getdate())) order by rank

Overall Enquiry Volume for April 2013

Rank	Country	Share	Change	Comment
1	USA	18.97	Non-mover	1 month in top spot
2	Spain	10.16	Non-mover
3	Thailand	6.78	Up 14	New to top 10!
4	Cayman Islands	6.6	Up 15	Highest climber And New to top 10!
5	brazil	5.69	Down 2
6	France	4.98	Down 2
7	Portugal	4.83	Down 2
8	Turkey	4.47	Down 2
9	Italy	3.18	Up 1
10	Germany	2.61	Down 1
11	Bulgaria	2.19	Up 4
12	Hungary	2.13	Down 4
13	Belize	1.85	Non-mover
14	Cape Verde	1.81	Down 7
15	St Kitts and Nevis	1.4	Up 12
16	Seychelles	1.4		Highest New Entry
17	Cyprus	1.38	Up 1
18	Greece	1.29	Down 2
19	Barbados	1.23	Down 8
20	India	1.16	Up 6
21	Croatia	0.92	Down 9
22	Malta	0.88	Down 2
23	Egypt	0.8	Up 2
24	Poland	0.76	Down 3
25	UAE	0.71	Down 11
26	St Lucia	0.44	Down 4
27	Please select a country	0.4		New Entry
28	Montenegro	0.33	Non-mover
29	Jamaica	0.33	Down 5
30	Sweden	0.31		New Entry
31	Mexico	0.28	Non-mover
32	CANADA	0.23	Up 13
33	Albania	0.2	Up 4
34	Dominican Republic	0.2	Up 1
35	Czech Republic	0.19	Down 12	Biggest faller
36	St Vincent and Grenadines	0.17	Down 7
37	Romania	0.15	Up 11
38	South Africa	0.12	Down 8
39	Philippines	0.11	Non-mover
40	Malaysia	0.08	Down 8