(Italiano) SQL: esercizio 1 sulle query

Sorry, this entry is only available in Italian.

This entry was posted in Senza categoria. Bookmark the permalink.

2 Responses to (Italiano) SQL: esercizio 1 sulle query

  1. Francesco Bragadin says:

    Il punto 4 è indubbiamente complesso: la soluzione è:

    SELECT b.cognome, SUM(a.somma)
    FROM multe AS A, persone AS B
    WHERE a.idpersona=b.idpersona
    GROUP BY a.idpersona, b.cognome

  2. Francesco Bragadin says:

    il punto 6, 7 e 8 segue il seguente criterio

    SELECT
    a.nome,
    a.cognome,
    b.datamulta
    FROM
    persone AS a,
    multe AS b
    WHERE
    a.idpersona=b.idpersona
    AND
    b.datamulta between #01/01/2005# and #31/12/2005#

Leave a Reply to Francesco Bragadin Cancel reply

Your email address will not be published. Required fields are marked *