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 |
