Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- ----------
- -- QUERY 1.13
- -- ----------
- SELECT cognome , nome , classe
- FROM studenti
- WHERE (
- cognome LIKE 'R%'
- )
- ORDER BY cognome ASC;
- -- ----------
- -- QUERY 1.14
- -- ----------
- SELECT cognome, nome, descrizione
- FROM docenti
- JOIN materie on materie.idMateria = docenti.idDocente
- WHERE descrizione LIKE 'ita%' OR 'let%' OR 'sto';
- -- ----------
- -- QUERY 1.15
- -- ----------
- SELECT cognome , nome , classe, AVG(voto)
- FROM studenti
- JOIN prove on prove.idProva = studenti.idStudente
- GROUP BY voto
- HAVING voto between 3 AND 8
- -- ----------
- -- QUERY 1.16
- -- ----------
- SELECT cognome , nome , classe , AVG(voti)
- FROM studenti
- JOIN prove on prove.idProva = studenti.idStudente
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement