Table:
team
from
to
record

m
w
d
l
win %
ref

asc schoppingen
1 july 1987
30 june 1992
151
63
51
37
41.72
none

sc verl
1 july 1992
1 februar 1994
52
26
16
10
50.00
none

vfl bochum
26 october 1999
23 december 1999
9
6
1
2
66.67
none

vfl bochum
1 july 2001
3 december 2001
16
7
6
3
43.75
none

msv duisburg
4 november 2002
20 november 2002
7
5
0
2
71.43
none

lr ahlen
1 july 2006
29 october 2006
14
4
2
8
28.57
none

total
111
54
29
28
48.65
-

Statement: bernard dietz was coach of asc schoppingen from 1 july 1987 to 30 june 1992.
Question: when has bernard dietz been a coach of asc schoppingen?
Answer: 1 july 1987, 30 june 1992