CREATE TABLE station_record_count AS SELECT station_STN, station_wban, COUNT(*) AS count FROM Parameters_fact GROUP BY station_STN, station_wban