SQL Explorer Cours --------------------------ClassesGarageSandbox--------------------------AssociationsSpectacle--------------------------ValidationCinema--------------------------ContraintesIntegritePalettesPapier--------------------------HeritageEtCyclesAtelierFabricationExercices Supplémentaires--------------------------UNILTennisPolicliniqueEmployeDepartementCroisiereAeroClubColloqueLibrairieArmateurCourseDePatrouillesFondationDInteretPublic--------------------------NotesEntrepotDonneesFabriqueFiltres

SELECT Nom
FROM Client

SELECT Nom, Adresse
FROM Client
WHERE Adresse = 'Lausanne'

SELECT *
FROM Client
WHERE Adresse = 'Lausanne'

SELECT *
FROM Client
WHERE Adresse = 'Lausanne'
ORDER BY Nom ASC

SELECT *
FROM   Sinistre
WHERE  Date > '2009-1-1'
AND    Montant > 3000

SELECT *
FROM   Contrat
WHERE  Type LIKE 'RC + Casco%'

SELECT 'Montant en Euros de ', Reference, Date, 0.65 * Montant
FROM   Sinistre
WHERE  Date > '1/10/2009'

SELECT SUM( Montant )
FROM   Sinistre

SELECT SUM( Montant ) AS Total_Sinistres
FROM   Sinistre

SELECT COUNT(*) AS NombreVW
FROM   Vehicule
WHERE  Marque = 'VW'

SELECT *
FROM   Vehicule
WHERE  Cylindree > (
        SELECT AVG(Cylindree)
        FROM   Vehicule )