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	Smart Ticketing	Sun Jul 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100188917	2894.75	ROBERT WALTERS PLC
TfGM	Transport	Smart Ticketing	Sun Jul 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100189852	2750	ROBERT WALTERS PLC
TfGM	Transport	Capital Costs - Project Support Services	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100187661	19130.75	ATKINS CONSULTANTS LTD
TfGM	Corporate Services	IS Support and Licences	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100188231	12474	ATKINS CONSULTANTS LTD
TfGM	Transport	Cycle Training Scheme	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100189098	1440	BIKERIGHT! LTD
TfGM	Transport	Capital Costs - Utility & Service Diversion Costs	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100189476	539.04	BT OPENREACH (SALFORD)
TfGM	Transport	Print & Media	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100188716	-482	CESTRIAN IMAGING LTD
TfGM	Transport	Print & Media	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100188717	1135	CESTRIAN IMAGING LTD
TfGM	Transport	Smart Ticketing	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100189285	2720	COMPUTER FUTURES
TfGM	Transport	Vehicle Costs	Mon Jul 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	5100189488	15600	DIAMOND BUS (NORTH WEST) LTD


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