SQLZoo JOIN 13

	A	B	C	D	E	G	H	I	J	K	L	M	N	O
1	Results that I SHOULD get					Results I'm ACTUALLY getting
2	mdate	team1	score1	team2	score2	mdate	team1	COUNT(go1.tea..	team2	COUNT(go2.tea..	mesmo jogo	t1	t2
3	1 July 2012	ESP	4	ITA	0	1 July 2012	ESP	4	ITA	0	TRUE	TRUE	TRUE	FALSE
4	10 June 2012	ESP	1	ITA	1	10 June 2012	ESP	1	ITA	1	TRUE	TRUE	TRUE	FALSE
5	10 June 2012	IRL	1	CRO	3	10 June 2012	IRL	3	CRO	3	TRUE	FALSE	TRUE	FALSE
6	11 June 2012	FRA	1	ENG	1	11 June 2012	FRA	1	ENG	1	TRUE	TRUE	TRUE	FALSE
7	11 June 2012	UKR	2	SWE	1	11 June 2012	UKR	2	SWE	2	TRUE	TRUE	FALSE	FALSE
8	12 June 2012	GRE	1	CZE	2	12 June 2012	GRE	2	CZE	2	TRUE	FALSE	TRUE	FALSE
9	12 June 2012	POL	1	RUS	1	12 June 2012	POL	1	RUS	1	TRUE	TRUE	TRUE	FALSE
10	13 June 2012	DEN	2	POR	3	13 June 2012	DEN	6	POR	6	TRUE	FALSE	FALSE	FALSE
11	13 June 2012	NED	1	GER	2	13 June 2012	NED	2	GER	2	TRUE	FALSE	TRUE	FALSE
12	14 June 2012	ITA	1	CRO	1	14 June 2012	ITA	1	CRO	1	TRUE	TRUE	TRUE	FALSE
13	14 June 2012	ESP	4	IRL	0	14 June 2012	ESP	4	IRL	0	TRUE	TRUE	TRUE	FALSE
14	15 June 2012	UKR	0	FRA	2	15 June 2012	UKR	0	FRA	2	TRUE	TRUE	TRUE	FALSE
15	15 June 2012	SWE	2	ENG	3	15 June 2012	SWE	6	ENG	6	TRUE	FALSE	FALSE	FALSE
16	16 June 2012	CZE	1	POL	0	16 June 2012	CZE	1	POL	0	TRUE	TRUE	TRUE	FALSE
17	16 June 2012	GRE	1	RUS	0	16 June 2012	GRE	1	RUS	0	TRUE	TRUE	TRUE	FALSE
18	17 June 2012	POR	2	NED	1	17 June 2012	POR	2	NED	2	TRUE	TRUE	FALSE	FALSE
19	17 June 2012	DEN	1	GER	2	17 June 2012	DEN	2	GER	2	TRUE	FALSE	TRUE	FALSE
20	18 June 2012	CRO	0	ESP	1	18 June 2012	CRO	0	ESP	1	TRUE	TRUE	TRUE	FALSE
21	18 June 2012	ITA	2	IRL	0	18 June 2012	ITA	2	IRL	0	TRUE	TRUE	TRUE	FALSE
22	19 June 2012	ENG	1	UKR	0	19 June 2012	ENG	1	UKR	0	TRUE	TRUE	TRUE	FALSE
23	19 June 2012	SWE	2	FRA	0	19 June 2012	SWE	2	FRA	0	TRUE	TRUE	TRUE	FALSE
24	21 June 2012	CZE	0	POR	1	21 June 2012	CZE	0	POR	1	TRUE	TRUE	TRUE	FALSE
25	22 June 2012	GER	4	GRE	2	22 June 2012	GER	8	GRE	8	TRUE	FALSE	FALSE	FALSE
26	23 June 2012	ESP	2	FRA	0	23 June 2012	ESP	2	FRA	0	TRUE	TRUE	TRUE	FALSE
27	24 June 2012	ENG	0	ITA	0	24 June 2012	ENG	0	ITA	0	TRUE	TRUE	TRUE	TRUE
28	27 June 2012	POR	0	ESP	0	27 June 2012	POR	0	ESP	0	TRUE	TRUE	TRUE	TRUE
29	28 June 2012	GER	1	ITA	2	28 June 2012	GER	2	ITA	2	TRUE	FALSE	TRUE	FALSE
30	8 June 2012	POL	1	GRE	1	8 June 2012	POL	1	GRE	1	TRUE	TRUE	TRUE	FALSE
31	8 June 2012	RUS	4	CZE	1	8 June 2012	RUS	4	CZE	4	TRUE	TRUE	FALSE	FALSE
32	9 June 2012	NED	0	DEN	1	9 June 2012	NED	0	DEN	1	TRUE	TRUE	TRUE	FALSE
33	9 June 2012	GER	1	POR	0	9 June 2012	GER	1	POR	0	TRUE	TRUE	TRUE	FALSE
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100