Invoice ID	Year	Month	Supplier	Product ID	Payment (million)	Late payment
111	2016	1	Vid Inc.	speaker	8	yes
112	2016	2	MBX Comp.	monitor	6	yes
113	2016	3	Green Tech Inc.	monitor	4	no
114	2016	4	Tech Sol Inc.	network cable	5	no
115	2016	5	Vin tech Inc.	network cable	5	no
116	2016	6	Vid Inc.	server	2	no
117	2016	7	MBX Comp.	server	7	no
118	2016	8	Greentree Inc.	server	7	yes
119	2016	9	Tech Sol Inc.	speaker	0	yes
120	2016	10	Vin tech Inc.	monitor	7	no
121	2016	11	Vid Inc.	monitor	1	no
122	2016	12	MBX Comp.	network cable	3	no
123	2016	1	Greentree Inc.	network cable	0	no
124	2016	2	Tech Sol Inc.	server	0	no
125	2016	3	Vin tech Inc.	server	8	yes
126	2016	4	Vid Inc.	server	3	yes
127	2016	5	MBX Comp.	speaker	1	no
128	2016	6	Greentree Inc.	monitor	9	no
129	2016	7	Tech Sol Inc.	monitor	4	no
130	2016	8	Vin tech Inc.	network cable	3	no
131	2016	9	Vid Inc.	network cable	4	no
132	2016	10	MBX Comp.	server	9	yes
133	2016	11	Greentree Inc.	server	8	yes
134	2016	12	Tech Sol Inc.	server	5	no
135	2016	1	Vin tech Inc.	speaker	2	no
136	2016	2	Vid Inc.	monitor	2	no
137	2016	3	MBX Comp.	monitor	3	no
138	2016	4	Greentree Inc.	network cable	9	no
139	2016	5	Tech Sol Inc.	network cable	6	yes
140	2016	6	Vin tech Inc.	server	9	yes
141	2016	7	Vid Inc.	server	2	no
142	2016	8	MBX Comp.	server	4	no
143	2016	9	Greentree Inc.	speaker	0	no
144	2016	10	Tech Sol Inc.	monitor	6	no
145	2016	11	Vin tech Inc.	monitor	4	no
146	2016	12	Vid Inc.	network cable	8	yes
147	2017	1	MBX Comp.	network cable	7	yes
148	2017	2	Vin tech Inc.	server	7	no
149	2017	3	Vid Inc.	server	0	no
150	2017	4	MBX Comp.	server	5	no
151	2017	5	Greentree Inc.	speaker	3	no
152	2017	6	Vin tech Inc.	monitor	7	no
153	2017	7	Vid Inc.	monitor	4	yes
154	2017	8	MBX Comp.	network cable	9	yes
155	2017	9	Greentree Inc.	network cable	4	no
156	2017	10	Vid Inc.	server	2	no
157	2017	11	MBX Comp.	server	8	no
158	2017	12	Greentree Inc.	server	5	no

Q1	Find the number of time that our company miss a payment (which means Late Payment = Yes)
	with value greater than 6 million
	yes	>6	9
Q2	Find the number of time that our company miss a payment for Vid Inc.
Q3	Find the number of time that our company miss a payment (which means Late Payment = Yes)
	in January of any year with value greater than 8 million
Q4	Find the number of time that our company pay ontime (which means Late Payment = No)
	with value greater than 4 million and in May of any year
Q5	Find the number of time that our company pay ontime (which means Late Payment = No)
	with value LESS than 5 million and in Jan, Feb, March and April of any year
Q6	Sum the value of all late payments made to Tech Sol Inc.
Q7	Sum the value of all late payments associated with purchase of server
Q8	Sum the value of all late payments associated with server purchases of more than 7 million