# data[].attributes.body
http://areastudi.legacoop.coop/wp-content/uploads/2017/12/Istat-.pdf

# data[].attributes.body
1.
SELECT *
FROM Dipendenti
WHERE dipartimento in("A", "B", "D") and Qualifica in("D","C");

2.
SELECT COUNT(*) AS numero
FROM Dipendenti
WHERE dipartimento="A" and YEAR(DATE())-YEAR(dataNascita)>50;

3.
SELECT MAX(Stipendio) AS StipendioMassimo, Dipartimento
FROM Dipendenti
GROUP BY Dipartimento;

4.
SELECT Qualifica
FROM Dipendenti
DISTINCT Qualifica;

5.
SELECT *
FROM Dipendenti
WHERE Qualifica in("D","C")
ORDER BY Stipendio;

6.
SELECT AVG(Stipendio) AS Media
FROM Dipendenti
GROUP BY Dipartimento;

7.
SELECT Stipendio-(Stipendio*10/100) As Stimpendio_10%
FROM Dipendenti
WHERE Stipendio between [Prezzo minimo] AND [Prezzo massimo];

8.
SELECT SUM(Stipendio), Dipartimento
FROM Dipendenti
GROUP BY Dipartimento;

9.
SELECT SUM(Stipendio), Dipartimento
FROM Dipendenti
WHERE Qualifica="C"
GROUP BY Dipartimento;

10.
SELECT *
FROM Dipendenti
WHERE Qualifica="D" AND dataNascita>[Inserisci data di nascita]
ORDER BY Dipartimento;