TfGM Spending Over £500

body_name Body Name	service_area Service Area	expense_type Expense Type	invoice_payment_date Invoice Payment Date	transaction_number Transaction Number	net_amount Net Amount	supplier_name Supplier Name
TfGM	Transport	Legal Services	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117555	4505.95	11KBW
TfGM	Transport	Planning Support Services	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117353	5216.96	AECOM LTD
TfGM	Transport	Community Engagement Support Services	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117361	5236.6	AECOM LTD
TfGM	Transport	Planning Support Services	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117388	2213.21	AECOM LTD
TfGM	Transport	Project Management Services	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117433	9884	AECOM LTD
TfGM	Transport	Planning Support Services	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117581	8516.15	AECOM LTD
TfGM	Corporate Services	Insurance	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1900058083	5000	ALLIANZ INSURANCE PLC
TfGM	Transport	Vehicle Costs	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1200047416	659.6	ALLSTAR
TfGM	Transport	Print & Media	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117397	500	ANDOTWIN STUDIO LTD
TfGM	Corporate Services	Smart Ticketing	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5100117436	19444.45	APPLIED CARD TECHNOLOGIES


CREATE TABLE n_4th_quarter_2017_18 (
  "body_name" VARCHAR,
  "service_area" VARCHAR,
  "expense_type" VARCHAR,
  "invoice_payment_date" TIMESTAMP,
  "transaction_number" BIGINT,
  "net_amount" DOUBLE,
  "supplier_name" VARCHAR
);