Table: macclesfield_elections
Columns: election
1st_member
1st_party
2nd_member
2nd_party

Question: Which 1st member has Thomas Grimsditch as a 2nd member?
SQL: SELECT "1st_member" FROM macclesfield_elections WHERE "2nd_member" = 'thomas grimsditch'

Question: What is all the total election that has conservative as 2nd party?
SQL: SELECT SUM("election") FROM macclesfield_elections WHERE "2nd_party" = 'conservative'

Question: Which 1st party has John Brocklehurst as 1st member, Edward Christopher Egerton 2nd memeber, and election smaller than 1880?
SQL: SELECT "1st_party" FROM macclesfield_elections WHERE "election" < 1880 AND "1st_member" = 'john brocklehurst' AND "2nd_member" = 'edward christopher egerton'

Question: Which 1st party has 2nd party conservative, election smaller than 1852, and Thomas Grimsditch as 2nd member?
SQL: SELECT "1st_party" FROM macclesfield_elections WHERE "2nd_party" = 'conservative' AND "election" < 1852 AND "2nd_member" = 'thomas grimsditch'