Table: shooting_thaler
Columns: location
date
denomination
coinage_metal
mintage
km_number

Question: What is the coinage metal for a KM number of S75?
SQL: SELECT "coinage_metal" FROM shooting_thaler WHERE "km_number" = 'S75'

Question: What is the maximum date for a mintage of 150 and a KM number of S66?
SQL: SELECT MAX("date") FROM shooting_thaler WHERE "mintage" = 150 AND "km_number" = 'S66'

Question: What is the mintage for a location of Sion and a denomination of 00500 500 Francs?
SQL: SELECT "mintage" FROM shooting_thaler WHERE "location" = 'Sion' AND "denomination" = '00500 500 francs'

Question: What is the coinage metal for KM numbers of S45?
SQL: SELECT "coinage_metal" FROM shooting_thaler WHERE "km_number" = 'S45'

Question: What is the coinage metal for a location of Fribourg and denomination of 00005 5 Francs?
SQL: SELECT "coinage_metal" FROM shooting_thaler WHERE "location" = 'Fribourg' AND "denomination" = '00005 5 francs'