1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| 1. SELECT * FROM cinema;
2. SELECT titre FROM film;
3. SELECT titre FROM film ORDER BY titre;
4. SELECT titre FROM film WHERE TO_CHAR(datesortie,'YYYY')>='1995';
5. SELECT titre FROM film WHERE TO_CHAR(datesortie,'YYYY')>='1980'AND TO_CHAR(datesortie,'YYYY')<=1995 ORDER BY titre DESC;
6. SELECT titre,datesortie FROM film WHERE TO_CHAR(datesortie,'YYYY')<1999 AND titre LIKE'%in%'; SELECT (datesortie) AS Sortie FROM film;
7. SELECT nom,prenom FROM acteur;
8. SELECT cinema.nom AS cinema ,acteur.nom AS acteur FROM cinema,acteur;
9.SELECT nom,prenom FROM acteur WHERE nom LIKE'D%';
10.SELECT UPPER(nom)||' '||INITCAP(SUBSTR(prenom,1,1))||'.' FROM acteur;
11. SELECT TO_CHAR(heuredbt,'HH24:Mi'), TO_CHAR(heurefin,'HH24:Mi') FROM seance;
12.SELECT TO_CHAR(heuredbt,'HH24:Mi'),TO_CHAR(heurefin,'HH24:Mi') FROM seance WHERE TO_CHAR(heuredbt,'HH24')>='19:00';
13.SELECT TO_CHAR(heuredbt,'HH24:Mi') AS Debut ,TO_CHAR(heurefin,'HH24:Mi') AS Fin FROM seance WHERE TO_CHAR(heuredbt,'HH24')>='19:00';
14.SELECT TO_CHAR(heuredbt,'HH24:Mi') AS Debut ,TO_CHAR(heurefin,'HH24:Mi') AS Fin, (heurefin-heuredbt)*24*60 AS DureeMn FROM seance WHERE TO_CHAR(heuredbt,'HH24')>='21:00';
15. SELECT TO_CHAR(heuredbt,'HH24:Mi') FROM seance WHERE numsalle=1 and cine=1;
16.SELECT AVG(prix) FROM seance;
17. SELECT COUNT(*),casting.personnage,film.titre FROM casting,film WHERE casting.idfilm=film.idfilm GROUP BY casting.personnage,film.titre;
18 SELECT COUNT(*),casting.personnage FROM casting,film WHERE casting.idfilm=film.idfilm GROUP BY casting.personnage HAVING COUNT(*)>=2;
19 SELECT prenom, COUNT(*) FROM acteur GROUP BY prenom
20. SELECT max(TO_CHAR(heurefin,HH24 :Mi)) FROM Seance |
Partager