Premiere requete SQL

Les classes sont :

1i1 1i2 1A 1E 1L1 1L2 1L3 1L4 1L5 1L6 1L7 1P 2A 2E 2I1 2I2 2L1 2L2 2L3 2L4 2L5 2L6 2L7 2P 3A 3E 3I1 3I2 3L1 3L2 3L3 3L4 3L5 3L6 3P 4A 4E 4I1 4I2 4P cm11 cm12 cm21 cm22 cm31 cm32 cm33 cm41 cm42 ECV M411 M412 M415 M416 M453 M454 Prof. M417 3L7

Les matchs sont :

347 2012-10-29 13:10:00
348 2012-10-29 13:55:00
349 2012-11-12 13:40:00
350 2012-10-30 13:10:00
351 2012-11-06 13:55:00
352 2012-11-06 13:10:00
353 2012-11-12 13:25:00
354 2012-10-29 13:25:00
355 2012-11-08 13:25:00
356 2012-11-06 13:40:00
357 2012-11-07 13:55:00
358 2012-11-12 13:55:00
359 2012-11-12 13:10:00
360 2012-10-30 13:40:00
361 2012-10-30 13:55:00
362 2012-11-05 13:40:00
363 2012-11-07 13:25:00
364 2012-10-30 13:25:00
365 2012-10-29 13:40:00
366 2012-11-06 13:25:00
367 2012-11-13 13:10:00
368 2012-10-31 13:25:00
369 2012-10-31 13:55:00
370 2012-11-07 13:10:00
371 2012-11-08 13:10:00
372 2012-11-08 13:55:00
373 2012-10-31 13:40:00
374 2012-11-13 13:25:00
375 2012-11-08 13:40:00
376 2012-10-31 13:10:00
377 2012-11-05 13:10:00
378 2012-11-09 13:25:00
379 2012-11-09 13:55:00
380 2012-11-13 13:55:00
381 2012-11-05 13:25:00
382 2012-11-13 13:40:00
383 2012-11-09 13:40:00
384 2012-11-07 13:40:00
385 2012-11-05 13:55:00
386 2012-11-09 13:10:00
390 2012-10-29 13:10:00
402 2012-11-14 13:10:00
403 2012-11-14 13:30:00
404 2012-11-15 13:10:00
405 2012-11-15 13:30:00
406 2012-11-19 13:10:00
407 2012-11-19 13:30:00
408 2012-11-20 13:10:00
409 2012-11-20 13:30:00