Requête : Comment avoir par prof, le nombre de cours fait par mois :

Bonjour,
< script de création et des insert ci-dessous.>

comment avoir par prof, le nombre de cours fait par mois :
mon pb est que je ne sais comment mettre les mois en horizontal.

par exemple :

PROFS Jan Fev Mar etc
-
Prof 1 10 25 32
Prof 2 10 25 32
Prof 3 10 25 32
-
Total 30 75 96

merci

--<Script>
USE [master]
GO
/****** Objet : Database [ecole] Date de génération du script :
02/03/2008 17:47:21 ******/
CREATE DATABASE [ecole] ON PRIMARY
( NAME = N'ecole', FILENAME = N'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\ecole.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED,
FILEGROWTH = 1024KB )
LOG ON
( NAME = N'ecole_log', FILENAME = N'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\ecole_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB
, FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'ecole', @new_cmptlevel
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [ecole].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [ecole] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [ecole] SET ANSI_NULLS OFF
USE [ecole]
GO
/****** Objet : Table [dbo].[profs] Date de génération du script :
02/03/2008 17:47:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[profs](
[prof_id] [int] IDENTITY(1,1) NOT NULL,
[nom] [nchar](10) NULL,
CONSTRAINT [PK_profs] PRIMARY KEY CLUSTERED
(
[prof_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Objet : Table [dbo].[eleves] Date de génération du script :
02/03/2008 17:47:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[eleves](
[eleve_id] [int] IDENTITY(1,1) NOT NULL,
[nom] [nchar](10) NULL,
CONSTRAINT [PK_eleves] PRIMARY KEY CLUSTERED
(
[eleve_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Objet : Table [dbo].[matieres] Date de génération du script :
02/03/2008 17:47:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[matieres](
[matiere_id] [int] IDENTITY(1,1) NOT NULL,
[libelle] [nchar](30) NULL,
CONSTRAINT [PK_lecons] PRIMARY KEY CLUSTERED
(
[matiere_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Objet : Table [dbo].[cours] Date de génération du script :
02/03/2008 17:47:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cours](
[cour_id] [int] IDENTITY(1,1) NOT NULL,
[matiere_id] [int] NULL,
[prof_id] [int] NULL,
[eleve_id] [int] NULL,
[date_cour] [datetime] NULL,
CONSTRAINT [PK_cours] PRIMARY KEY CLUSTERED
(
[cour_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO



INSERT INTO eleves (nom) VALUES ('Toto')
INSERT INTO eleves (nom) VALUES ('Tata')
INSERT INTO eleves (nom) VALUES ('Titi')

INSERT INTO profs (nom) VALUES ('Prof 1')
INSERT INTO profs (nom) VALUES ('Prof 2')
INSERT INTO profs (nom) VALUES ('Prof 3')

INSERT INTO matieres (libelle) VALUES ('Anglais')
INSERT INTO matieres (libelle) VALUES ('Maths')
INSERT INTO matieres (libelle) VALUES ('Francais')

INSERT INTO cours (prof_id, eleve_id,date_cour) VALUES (1,1,GetDate())
INSERT INTO cours (prof_id, eleve_id,date_cour) VALUES (1,2,GetDate())
INSERT INTO cours (prof_id, eleve_id,date_cour) VALUES (1,3,GetDate())
INSERT INTO cours (prof_id, eleve_id,date_cour) VALUES (2,2,GetDate())
INSERT INTO cours (prof_id, eleve_id,date_cour) VALUES (2,1,GetDate())
INSERT INTO cours (prof_id, eleve_id,date_cour) VALUES (3,1,GetDate())

--</script>