Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Microsoft Windows [Version 10.0.17763.195]
- (c) 2018 Microsoft Corporation. ALL rights reserved.
- C:\Users\Andrew>sqlplus /nolog
- SQL*Plus: RELEASE 11.2.0.2.0 Production ON Sat Dec 29 14:36:43 2018
- Copyright (c) 1982, 2014, Oracle. ALL rights reserved.
- SQL> conn STUDENT/STUDENT@localhost/XE
- Connected.
- SQL> SELECT REVERSE(studenti.nume)"Nume"
- 2
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM ;
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM
- *
- ERROR AT line 1:
- ORA-00903: invalid TABLE name
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti WHERE bursa IS NULL;
- Nume Prenume
- ---------- ----------------------------------------
- ucsepoP Bgdn
- naecpilerP Rd
- erihrA Rlc
- etianaP lxndr
- randoB n
- randoB n
- erihrA lxndr
- rucuB ndr
- 8 ROWS selected.
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti WHERE bursa IS NULL AND (SELECT ;
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti WHERE bursa IS NULL AND (SELECT
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL>
- SQL> SELECT DISTINCT nume, prenume
- 2 FROM studenti s, note n
- 3 WHERE s.nr_matricol=n.nr_matricol AND valoare>
- 4 (SELECT MAX(valoare)
- 5 FROM studenti s, note n
- 6 WHERE s.nr_matricol=n.nr_matricol AND nume='Archip')
- 7 AND grupa=
- 8 (SELECT grupa FROM studenti WHERE nume='Archip')
- 9 ORDER BY nume, prenume;
- NUME PRENUME
- ---------- ----------
- Bodnar Ioana
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE bursa IS NULL AND grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL);
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE bursa IS NULL AND grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL)
- *
- ERROR AT line 1:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE bursa IS NULL;
- Nume Prenume
- ---------- ----------------------------------------
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- naecpilerP Rd
- naecpilerP Rd
- naecpilerP Rd
- naecpilerP Rd
- naecpilerP Rd
- Nume Prenume
- ---------- ----------------------------------------
- naecpilerP Rd
- erihrA Rlc
- erihrA Rlc
- erihrA Rlc
- erihrA Rlc
- erihrA Rlc
- erihrA Rlc
- etianaP lxndr
- etianaP lxndr
- etianaP lxndr
- etianaP lxndr
- Nume Prenume
- ---------- ----------------------------------------
- etianaP lxndr
- etianaP lxndr
- randoB n
- randoB n
- randoB n
- randoB n
- randoB n
- randoB n
- 30 ROWS selected.
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING bursa IS NULL;
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING bursa IS NULL
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING studenti.bursa IS NULL;
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING studenti.bursa IS NULL
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa HAVING studenti.bursa IS NULL;
- Nume Prenume
- ---------- ----------------------------------------
- erihrA Rlc
- randoB n
- etianaP lxndr
- ucsepoP Bgdn
- naecpilerP Rd
- randoB n
- 6 ROWS selected.
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa, studenti.grupa HAVING studenti.bursa IS NULL AND studenti.grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL);
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa, studenti.grupa HAVING studenti.bursa IS NULL AND studenti.grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL)
- *
- ERROR AT line 1:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa, studenti.grupa HAVING studenti.bursa IS NULL AND studenti.grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL);
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa, studenti.grupa HAVING studenti.bursa IS NULL AND studenti.grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL)
- *
- ERROR AT line 1:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE studenti.bursa IS NULL AND studenti.grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL);
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE studenti.bursa IS NULL AND studenti.grupa = (SELECT grupa FROM studenti WHERE bursa IS NOT NULL)
- *
- ERROR AT line 1:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE studenti.bursa IS NULL AND (an,grupa) IN (SELECT an, grupa FROM studenti WHERE bursa IS NOT NULL)
- 2 ;
- Nume Prenume
- ---------- ----------------------------------------
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- ucsepoP Bgdn
- naecpilerP Rd
- naecpilerP Rd
- naecpilerP Rd
- naecpilerP Rd
- naecpilerP Rd
- Nume Prenume
- ---------- ----------------------------------------
- naecpilerP Rd
- randoB n
- randoB n
- randoB n
- 15 ROWS selected.
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti WHERE studenti.bursa IS NULL AND (an,grupa) IN (SELECT s.an, s.grupa FROM studenti s JOIN note ON note.nr_matricol = s.nr_matricol WHERE s.bursa IS NOT NULL AND MIN(note.valoare)<5 GROUP BY studenti.nr_matricol);
- SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume" FROM studenti WHERE studenti.bursa IS NULL AND (an,grupa) IN (SELECT s.an, s.grupa FROM studenti s JOIN note ON note.nr_matricol = s.nr_matricol WHERE s.bursa IS NOT NULL AND MIN(note.valoare)<5 GROUP BY studenti.nr_matricol)
- *
- ERROR AT line 1:
- ORA-00920: invalid relational OPERATOR
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume"
- 2 FROM studenti WHERE studenti.bursa IS NULL
- 3 AND (an,grupa) IN
- 4 (SELECT s.an, s.grupa FROM studenti s JOIN note ON note.nr_matricol = s.nr_matricol WHERE s.bursa IS NOT NULL)
- 5 ;
- Nume Prenume
- ---------- ----------------------------------------
- naecpilerP Rd
- ucsepoP Bgdn
- randoB n
- SQL> SELECT REVERSE(studenti.nume)"Nume", REPLACE(TRANSLATE(studenti.prenume,'AEIOUaeiou','.'),'.',NULL)"Prenume"
- 2 FROM studenti WHERE studenti.bursa IS NULL
- 3 AND (an,grupa) IN
- 4 (SELECT s.an, s.grupa FROM studenti s JOIN note ON note.nr_matricol = s.nr_matricol GROUP BY s.nr_matricol, s.an, s.grupa, s.bursa, note.valoare
- 5 HAVING s.bursa IS NOT NULL
- 6 AND MIN(note.valoare) < 5);
- Nume Prenume
- ---------- ----------------------------------------
- ucsepoP Bgdn
- naecpilerP Rd
- randoB n
- SQL> SELECT studenti.nume||" "||studenti.prenume"pren" FROM studenti GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING LENGTH(studenti.nume) > AVG(LENGTH(studenti.prenume) AND LENGTH(studenti.prenume > AVG(LENGTH(studenti.nume);
- SELECT studenti.nume||" "||studenti.prenume"pren" FROM studenti GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING LENGTH(studenti.nume) > AVG(LENGTH(studenti.prenume) AND LENGTH(studenti.prenume > AVG(LENGTH(studenti.nume)
- *
- ERROR AT line 1:
- ORA-00907: missing right parenthesis
- SQL> SELECT studenti.nume||" "||studenti.prenume"pren" FROM studenti GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING LENGTH(studenti.nume) > AVG(LENGTH(studenti.prenume)) AND LENGTH(studenti.prenume > AVG(LENGTH(studenti.nume));
- SELECT studenti.nume||" "||studenti.prenume"pren" FROM studenti GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING LENGTH(studenti.nume) > AVG(LENGTH(studenti.prenume)) AND LENGTH(studenti.prenume > AVG(LENGTH(studenti.nume))
- *
- ERROR AT line 1:
- ORA-00907: missing right parenthesis
- SQL> SELECT studenti.nume||" "||studenti.prenume"pren" FROM studenti GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING LENGTH(studenti.nume) > AVG(LENGTH(studenti.prenume)) AND LENGTH(studenti.prenume) > AVG(LENGTH(studenti.nume));
- SELECT studenti.nume||" "||studenti.prenume"pren" FROM studenti GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING LENGTH(studenti.nume) > AVG(LENGTH(studenti.prenume)) AND LENGTH(studenti.prenume) > AVG(LENGTH(studenti.nume))
- *
- ERROR AT line 1:
- ORA-00904: " ": invalid identifier
- SQL> SELECT nume||" "||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH(prenume)) AND LENGTH(prenume) > AVG(LENGTH(nume));
- SELECT nume||" "||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH(prenume)) AND LENGTH(prenume) > AVG(LENGTH(nume))
- *
- ERROR AT line 1:
- ORA-00904: " ": invalid identifier
- SQL> SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH(prenume)) AND LENGTH(prenume) > AVG(LENGTH(nume));
- no ROWS selected
- SQL> SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH(SELECT AVG(prenume) FROM studenti GROUP BY nr_matricol, prenume)) AND LENGTH(prenume) > AVG(LENGTH(SELECT AVG(nume) FROM studenti GROUP BY nr_matricol, nume));
- SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH(SELECT AVG(prenume) FROM studenti GROUP BY nr_matricol, prenume)) AND LENGTH(prenume) > AVG(LENGTH(SELECT AVG(nume) FROM studenti GROUP BY nr_matricol, nume))
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH((SELECT AVG(prenume) FROM studenti GROUP BY nr_matricol, prenume))) AND LENGTH(prenume) > AVG(LENGTH((SELECT AVG(nume) FROM studenti GROUP BY nr_matricol, nume)));
- SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH((SELECT AVG(prenume) FROM studenti GROUP BY nr_matricol, prenume))) AND LENGTH(prenume) > AVG(LENGTH((SELECT AVG(nume) FROM studenti GROUP BY nr_matricol, nume)))
- *
- ERROR AT line 1:
- ORA-01722: invalid NUMBER
- SQL> SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH((SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol, prenume))) AND LENGTH(prenume) > AVG(LENGTH((SELECT AVG(LENGTH(nume)) FROM studenti GROUP BY nr_matricol, nume)));
- SELECT nume||' '||prenume"pren" FROM studenti GROUP BY nr_matricol, nume, prenume HAVING LENGTH(nume) > AVG(LENGTH((SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol, prenume))) AND LENGTH(prenume) > AVG(LENGTH((SELECT AVG(LENGTH(nume)) FROM studenti GROUP BY nr_matricol, nume)))
- *
- ERROR AT line 1:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3 LENGTH(nume) > (SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume)
- 4 AND
- 5 LENGTH(prenume) > (SELECT AVG(LENGTH(nume)) FROM studenti GROUP BY nume)
- 6 ;
- LENGTH(nume) > (SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume)
- *
- ERROR AT line 3:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3 LENGTH(nume) > (SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- 4 AND
- 5 LENGTH(prenume) > (SELECT AVG(LENGTH(nume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- 6 ;
- LENGTH(nume) > (SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- *
- ERROR AT line 3:
- ORA-01427: single-ROW subquery returns more than one ROW
- SQL> SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume;
- AVG(LENGTH(PRENUME))
- --------------------
- 6
- 7
- 9
- 5
- 7
- 6
- 5
- 4
- 7
- 9
- 6
- AVG(LENGTH(PRENUME))
- --------------------
- 5
- 6
- 13 ROWS selected.
- SQL> SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume;
- AVG(LENGTH(PRENUME))
- --------------------
- 9
- 7
- 7
- 6
- 9
- 6
- 6
- 7
- 4
- 5
- 6
- 11 ROWS selected.
- SQL> SELECT (AVG(SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume);
- SELECT (AVG(SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume)
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume;
- AVG(LENGTH(PRENUME))
- --------------------
- 9
- 7
- 7
- 6
- 9
- 6
- 6
- 7
- 4
- 5
- 6
- 11 ROWS selected.
- SQL> SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume;
- AVG(LENGTH(PRENUME))
- --------------------
- 9
- 7
- 7
- 6
- 9
- 6
- 6
- 7
- 4
- 5
- 6
- 11 ROWS selected.
- SQL>
- SQL>
- SQL> SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3 LENGTH(nume) > AVG(SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- 4 AND
- 5 LENGTH(prenume) > AVG(SELECT AVG(LENGTH(nume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- 6 ;
- LENGTH(nume) > AVG(SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- *
- ERROR AT line 3:
- ORA-00934: GROUP FUNCTION IS NOT allowed here
- SQL> SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3 LENGTH(nume) > ALL(SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- 4 AND
- 5 LENGTH(prenume) > ALL(SELECT AVG(LENGTH(nume)) FROM studenti GROUP BY nr_matricol,nume,prenume)
- 6 ;
- no ROWS selected
- SQL> SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY nr_matricol,nume,prenume;
- AVG(LENGTH(PRENUME))
- --------------------
- 6
- 7
- 9
- 5
- 7
- 6
- 5
- 4
- 7
- 9
- 6
- AVG(LENGTH(PRENUME))
- --------------------
- 5
- 6
- 13 ROWS selected.
- SQL> SELECT AVG(LENGTH(prenume)) FROM studenti GROUP BY prenume;
- AVG(LENGTH(PRENUME))
- --------------------
- 9
- 7
- 7
- 6
- 9
- 6
- 6
- 7
- 4
- 5
- 6
- 11 ROWS selected.
- SQL> SELECT SUM(AVG(LENGTH(prenume))) FROM studenti GROUP BY prenume;
- SUM(AVG(LENGTH(PRENUME)))
- -------------------------
- 72
- SQL> SELECT SUM(AVG(LENGTH(prenume))), COUNT(*) FROM studenti GROUP BY prenume;
- SUM(AVG(LENGTH(PRENUME))) COUNT(*)
- ------------------------- ----------
- 72 11
- SQL> SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume;
- SUM(AVG(LENGTH(PRENUME)))/COUNT(*)
- ----------------------------------
- 6.54545455
- SQL> SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3 LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume);
- pren
- ----------------------
- Popescu Bogdan
- Prelipcean Radu
- Antonie Ioana
- Panaite Alexandru
- Ciobotariu Ciprian
- Pintescu Andrei
- Cobzaru George
- 7 ROWS selected.
- SQL> AND
- SP2-0042: unknown command "AND" - rest OF line ignored.
- SQL> LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume);
- SP2-0734: unknown command beginning "length(pre..." - rest OF line ignored.
- SQL> ;
- 1 SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3* LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- SQL> SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3 LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume);
- pren
- ----------------------
- Popescu Bogdan
- Prelipcean Radu
- Antonie Ioana
- Panaite Alexandru
- Ciobotariu Ciprian
- Pintescu Andrei
- Cobzaru George
- 7 ROWS selected.
- SQL> AND
- SP2-0042: unknown command "AND" - rest OF line ignored.
- SQL> LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume);
- SP2-0734: unknown command beginning "length(pre..." - rest OF line ignored.
- SQL> ;SELECT nume||' '||prenume"pren" FROM studenti WHERE LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- SP2-0734: unknown command beginning ";select nu..." - rest OF line ignored.
- SQL> AND
- SP2-0042: unknown command "AND" - rest OF line ignored.
- SP2-0044: FOR a list OF known commands enter HELP
- AND TO leave enter EXIT.
- SQL> LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume)
- SP2-0734: unknown command beginning "length(pre..." - rest OF line ignored.
- SQL> ;
- 1 SELECT nume||' '||prenume"pren" FROM studenti
- 2 WHERE
- 3* LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- SQL>
- SQL> SELECT nume||' '||prenume"pren" FROM studenti WHERE LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- 2 AND
- 3 LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume)
- 4 ;SELECT nume||' '||prenume"pren" FROM studenti WHERE
- 5 LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- 6 AND
- 7 LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume);
- ;SELECT nume||' '||prenume"pren" FROM studenti WHERE
- *
- ERROR AT line 4:
- ORA-00911: invalid character
- SQL>
- SQL>
- SQL> SELECT nume||' '||prenume"pren" FROM studenti WHERE
- 2 LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- 3 AND
- 4 LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume);
- pren
- ----------------------
- Panaite Alexandru
- SQL>
- SQL>
- SQL>
- SQL> SELECT nume||' '||prenume"pren" FROM studenti WHERE
- 2 LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- 3 AND
- 4 LENGTH(prenume) > (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume);
- pren
- ----------------------
- Panaite Alexandru
- SQL> SELECT nume||' '||prenume"pren" FROM studenti WHERE
- 2 LENGTH(nume) > (SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume)
- 3 AND
- 4 LENGTH(prenume) < (SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume)
- 5 AND bursa IS NOT NULL;
- pren
- ----------------------
- Antonie Ioana
- Ciobotariu Ciprian
- Pintescu Andrei
- Cobzaru George
- SQL>
- SQL> SELECT SUM(AVG(LENGTH(prenume)))/COUNT(*) FROM studenti GROUP BY prenume;
- SUM(AVG(LENGTH(PRENUME)))/COUNT(*)
- ----------------------------------
- 6.54545455
- SQL> SELECT SUM(AVG(LENGTH(nume)))/COUNT(*) FROM studenti GROUP BY nume;
- SUM(AVG(LENGTH(NUME)))/COUNT(*)
- -------------------------------
- 7.18181818
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING variace(note.valoare) = ANY(MIN(variace(note.valoare)), MAX(variace(note.valoare));
- SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING variace(note.valoare) = ANY(MIN(variace(note.valoare)), MAX(variace(note.valoare))
- *
- ERROR AT line 1:
- ORA-00907: missing right parenthesis
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING variace(note.valoare) = ANY(MIN(variace(note.valoare)), MAX(variace(note.valoare)));
- SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING variace(note.valoare) = ANY(MIN(variace(note.valoare)), MAX(variace(note.valoare)))
- *
- ERROR AT line 1:
- ORA-00904: "VARIACE": invalid identifier
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING variace(note.valoare) = ANY(MIN(VARIANCE(note.valoare)), MAX(VARIANCE(note.valoare)));
- SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING variace(note.valoare) = ANY(MIN(VARIANCE(note.valoare)), MAX(VARIANCE(note.valoare)))
- *
- ERROR AT line 1:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING VARIANCE(note.valoare) = MIN(VARIANCE(note.valoare)) OR VARIANCE(note.valoare) = MAX(VARIANCE(note.valoare));
- SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare HAVING VARIANCE(note.valoare) = MIN(VARIANCE(note.valoare)) OR VARIANCE(note.valoare) = MAX(VARIANCE(note.valoare))
- *
- ERROR AT line 1:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = MIN(VARIANCE(note.valoare))
- 5 OR VARIANCE(note.valoare) = MAX(VARIANCE(note.valoare));
- HAVING VARIANCE(note.valoare) = MIN(VARIANCE(note.valoare))
- *
- ERROR AT line 4:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT VARIANCE(bursa) AS "Varianta" FROM studenti;
- Varianta
- ----------
- 5000
- SQL> OR VARIANCE(note.valoare) = MAX(VARIANCE(note.valoare));
- SP2-0734: unknown command beginning "OR varianc..." - rest OF line ignored.
- SQL>
- SQL>
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(ALL note.valoare) = MIN(VARIANCE(ALL note.valoare))
- 5 OR VARIANCE(ALL note.valoare) = MAX(VARIANCE(ALL note.valoare));
- HAVING VARIANCE(ALL note.valoare) = MIN(VARIANCE(ALL note.valoare))
- *
- ERROR AT line 4:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) =
- 5 (SELECT VARIANCE(valoare) FROM note);
- no ROWS selected
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) =
- 5 ANY(SELECT MIN(VARIANCE(valoare)), MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol);
- ANY(SELECT MIN(VARIANCE(valoare)), MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- *
- ERROR AT line 5:
- ORA-00913: too many VALUES
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) =
- 5 SOME(SELECT MIN(VARIANCE(valoare)), MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol);
- SOME(SELECT MIN(VARIANCE(valoare)), MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- *
- ERROR AT line 5:
- ORA-00913: too many VALUES
- SQL> SELECT MIN(VARIANCE(valoare)), MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol;
- MIN(VARIANCE(VALOARE)) MAX(VARIANCE(VALOARE))
- ---------------------- ----------------------
- 0 6.66666667
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = (SELECT MIN(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 5 OR VARIANCE(note.valoare) = (SELECT MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol);
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Bogdan 7 7
- Ioana 10 10
- Raluca 10 10
- Alexandru 7 7
- Ioana 10 10
- Ioana 9 9
- Andrada 7 7
- Ioana 7 7
- Radu 5 5
- Ioana 9 9
- Raluca 4 4
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Raluca 5 5
- Alexandru 8 8
- Ioana 8 8
- Radu 7 7
- Radu 4 4
- Ioana 4 4
- Raluca 9 9
- Andrada 4 4
- Ciprian 7 7
- Radu 6 6
- Ioana 7 7
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Alexandru 10 10
- Alexandru 9 9
- Ioana 9 9
- Raluca 6 6
- Andrada 6 6
- Bogdan 8 8
- Bogdan 9 9
- Bogdan 10 10
- 30 ROWS selected.
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = (SELECT MIN(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 5 OR VARIANCE(note.valoare) = (SELECT MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 6 ORDER BY MAX(note.valoare) DESC;
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Bogdan 10 10
- Ioana 10 10
- Raluca 10 10
- Alexandru 10 10
- Ioana 10 10
- Ioana 9 9
- Bogdan 9 9
- Ioana 9 9
- Alexandru 9 9
- Raluca 9 9
- Ioana 9 9
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Bogdan 8 8
- Alexandru 8 8
- Ioana 8 8
- Radu 7 7
- Ioana 7 7
- Andrada 7 7
- Bogdan 7 7
- Alexandru 7 7
- Ioana 7 7
- Ciprian 7 7
- Radu 6 6
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Raluca 6 6
- Andrada 6 6
- Raluca 5 5
- Radu 5 5
- Andrada 4 4
- Raluca 4 4
- Ioana 4 4
- Radu 4 4
- 30 ROWS selected.
- SQL>
- SQL>
- SQL>
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare), VARIANCE(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = (SELECT MIN(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 5 OR VARIANCE(note.valoare) = (SELECT MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 6 ORDER BY MAX(note.valoare) DESC;
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE) VARIANCE(NOTE.VALOARE)
- ---------- ----------------- ----------------- ----------------------
- Bogdan 10 10 0
- Ioana 10 10 0
- Raluca 10 10 0
- Alexandru 10 10 0
- Ioana 10 10 0
- Ioana 9 9 0
- Bogdan 9 9 0
- Ioana 9 9 0
- Alexandru 9 9 0
- Raluca 9 9 0
- Ioana 9 9 0
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE) VARIANCE(NOTE.VALOARE)
- ---------- ----------------- ----------------- ----------------------
- Bogdan 8 8 0
- Alexandru 8 8 0
- Ioana 8 8 0
- Radu 7 7 0
- Ioana 7 7 0
- Andrada 7 7 0
- Bogdan 7 7 0
- Alexandru 7 7 0
- Ioana 7 7 0
- Ciprian 7 7 0
- Radu 6 6 0
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE) VARIANCE(NOTE.VALOARE)
- ---------- ----------------- ----------------- ----------------------
- Raluca 6 6 0
- Andrada 6 6 0
- Raluca 5 5 0
- Radu 5 5 0
- Andrada 4 4 0
- Raluca 4 4 0
- Ioana 4 4 0
- Radu 4 4 0
- 30 ROWS selected.
- SQL>
- SQL>
- SQL> SELECT studenti.prenume, MAX(note.valoare), MIN(note.valoare), VARIANCE(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = (SELECT MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 5 ORDER BY MAX(note.valoare) DESC;
- no ROWS selected
- SQL> SELECT DISTINCT studenti.prenume, MAX(note.valoare), MIN(note.valoare), VARIANCE(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = (SELECT MIN(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 5 OR VARIANCE(note.valoare) = (SELECT MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 6 ORDER BY MAX(note.valoare) DESC;
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE) VARIANCE(NOTE.VALOARE)
- ---------- ----------------- ----------------- ----------------------
- Alexandru 10 10 0
- Bogdan 10 10 0
- Ioana 10 10 0
- Raluca 10 10 0
- Alexandru 9 9 0
- Bogdan 9 9 0
- Ioana 9 9 0
- Raluca 9 9 0
- Alexandru 8 8 0
- Bogdan 8 8 0
- Ioana 8 8 0
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE) VARIANCE(NOTE.VALOARE)
- ---------- ----------------- ----------------- ----------------------
- Alexandru 7 7 0
- Andrada 7 7 0
- Bogdan 7 7 0
- Ciprian 7 7 0
- Ioana 7 7 0
- Radu 7 7 0
- Andrada 6 6 0
- Radu 6 6 0
- Raluca 6 6 0
- Radu 5 5 0
- Raluca 5 5 0
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE) VARIANCE(NOTE.VALOARE)
- ---------- ----------------- ----------------- ----------------------
- Andrada 4 4 0
- Ioana 4 4 0
- Radu 4 4 0
- Raluca 4 4 0
- 26 ROWS selected.
- SQL> SELECT DISTINCT studenti.prenume, MAX(note.valoare), MIN(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.prenume, note.valoare
- 4 HAVING VARIANCE(note.valoare) = (SELECT MIN(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 5 OR VARIANCE(note.valoare) = (SELECT MAX(VARIANCE(valoare)) FROM note GROUP BY nr_matricol)
- 6 ORDER BY MAX(note.valoare) DESC;
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Alexandru 10 10
- Bogdan 10 10
- Ioana 10 10
- Raluca 10 10
- Alexandru 9 9
- Bogdan 9 9
- Ioana 9 9
- Raluca 9 9
- Alexandru 8 8
- Bogdan 8 8
- Ioana 8 8
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Alexandru 7 7
- Andrada 7 7
- Bogdan 7 7
- Ciprian 7 7
- Ioana 7 7
- Radu 7 7
- Andrada 6 6
- Radu 6 6
- Raluca 6 6
- Radu 5 5
- Raluca 5 5
- PRENUME MAX(NOTE.VALOARE) MIN(NOTE.VALOARE)
- ---------- ----------------- -----------------
- Andrada 4 4
- Ioana 4 4
- Radu 4 4
- Raluca 4 4
- 26 ROWS selected.
- SQL>
- SQL>
- SQL>
- SQL> SELECT studenti.anselect studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare;
- SELECT studenti.anselect studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL>
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare;
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 A2 7
- 3 A4 4
- 2 A1 6
- 2 A1 10
- 3 A2 6
- 2 A1 9
- 2 B2 7
- 3 A2 5
- 3 B3 10
- 2 B2 8
- 3 A2 10
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 A4 9
- 3 A4 10
- 3 B3 8
- 2 B2 9
- 3 A2 8
- 3 A2 9
- 3 A4 6
- 2 A1 7
- 2 A1 4
- 3 A2 4
- 3 A4 5
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 B3 7
- 3 B3 9
- 24 ROWS selected.
- SQL>
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare ORDER BY grupa ASC;
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 2 A1 4
- 2 A1 6
- 2 A1 7
- 2 A1 9
- 2 A1 10
- 3 A2 4
- 3 A2 5
- 3 A2 6
- 3 A2 7
- 3 A2 8
- 3 A2 9
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 A2 10
- 3 A4 4
- 3 A4 5
- 3 A4 6
- 3 A4 9
- 3 A4 10
- 2 B2 7
- 2 B2 8
- 2 B2 9
- 3 B3 7
- 3 B3 8
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 B3 9
- 3 B3 10
- 24 ROWS selected.
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa ORDER BY grupa ASC;
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 2 A1 7.44444444
- 3 A2 7.33333333
- 3 A4 6.33333333
- 2 B2 8
- 3 B3 9
- SQL>
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa HAVING AVG(note.valoare) = (SELECT MAX(AVG(note.valoare)) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa);
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 B3 9
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN (SELECT studenti.an, studenti.grupa FROM studenti
- 6 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 7 GROUP BY studenti.an, studenti.grupa
- 8 HAVING AVG(note.valoare) =
- 9 (SELECT MIN(AVG(note.valoare)) FROM studenti
- 10 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 11 GROUP BY studenti.an, studenti.grupa))
- 12 ;
- SELECT studenti.nume, studenti.prenume FROM studenti
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN (SELECT studenti.an, studenti.grupa FROM studenti
- 6 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 7 GROUP BY studenti.an, studenti.grupa
- 8 HAVING AVG(note.valoare) =
- 9 (SELECT MIN(AVG(note.valoare)) FROM studenti
- 10 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 11 GROUP BY studenti.an, studenti.grupa))
- 12 ;
- HAVING (studenti.an, studenti.grupa)
- *
- ERROR AT line 4:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.an, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN (SELECT studenti.an, studenti.grupa FROM studenti
- 6 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 7 GROUP BY studenti.an, studenti.grupa
- 8 HAVING AVG(note.valoare) =
- 9 (SELECT MIN(AVG(note.valoare)) FROM studenti
- 10 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 11 GROUP BY studenti.an, studenti.grupa))
- 12 ;
- NUME PRENUME
- ---------- ----------
- Arhire Raluca
- SQL> SELECT studenti.nume, studenti.prenume, studenti.an, studenti.grupa FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.an, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN (SELECT studenti.an, studenti.grupa FROM studenti
- 6 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 7 GROUP BY studenti.an, studenti.grupa
- 8 HAVING AVG(note.valoare) =
- 9 (SELECT MIN(AVG(note.valoare)) FROM studenti
- 10 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 11 GROUP BY studenti.an, studenti.grupa))
- 12 ;
- NUME PRENUME AN GR
- ---------- ---------- ---------- --
- Arhire Raluca 3 A4
- SQL> SELECT studenti.nume, studenti.prenume, studenti.an, studenti.grupa, note.valoare FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.an, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN (SELECT studenti.an, studenti.grupa FROM studenti
- 6 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 7 GROUP BY studenti.an, studenti.grupa
- 8 HAVING AVG(note.valoare) =
- 9 (SELECT MIN(AVG(note.valoare)) FROM studenti
- 10 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 11 GROUP BY studenti.an, studenti.grupa))
- 12 ;
- SELECT studenti.nume, studenti.prenume, studenti.an, studenti.grupa, note.valoare FROM studenti
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT nume, prenume FROM studenti
- 2 WHERE (an, grupa) IN
- 3 (
- 4 SELECT studenti.an, studenti.grupa FROM studenti
- 5 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 6 GROUP BY studenti.an, studenti.grupa, note.valoare
- 7 HAVING AVG(note.valoare) = MIN(AVG(note.valoare))
- 8 )
- 9 ;
- HAVING AVG(note.valoare) = MIN(AVG(note.valoare))
- *
- ERROR AT line 7:
- ORA-00920: invalid relational OPERATOR
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.an, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN (
- 6 SELECT studenti.an, studenti.grupa FROM studenti
- 7 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 8 GROUP BY studenti.an, studenti.grupa
- 9 HAVING AVG(note.valoare) = MIN(AVG(note.valoare))
- 10 )
- 11 ;
- HAVING AVG(note.valoare) = MIN(AVG(note.valoare))
- *
- ERROR AT line 9:
- ORA-00920: invalid relational OPERATOR
- SQL> SELECT studenti.an, studenti.grupa FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa, note.valoare;
- AN GR
- ---------- --
- 3 A2
- 3 A4
- 2 A1
- 2 A1
- 3 A2
- 2 A1
- 2 B2
- 3 A2
- 3 B3
- 2 B2
- 3 A2
- AN GR
- ---------- --
- 3 A4
- 3 A4
- 3 B3
- 2 B2
- 3 A2
- 3 A2
- 3 A4
- 2 A1
- 2 A1
- 3 A2
- 3 A4
- AN GR
- ---------- --
- 3 B3
- 3 B3
- 24 ROWS selected.
- SQL>
- SQL> SELECT studenti.an, studenti.grupa FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa;
- AN GR
- ---------- --
- 3 A2
- 3 A4
- 3 B3
- 2 B2
- 2 A1
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa;
- AN GR AVG(NOTE.VALOARE)
- ---------- -- -----------------
- 3 A2 7.33333333
- 3 A4 6.33333333
- 3 B3 9
- 2 B2 8
- 2 A1 7.44444444
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare), MIN(AVG(note.valoare)) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa;
- SELECT studenti.an, studenti.grupa, AVG(note.valoare), MIN(AVG(note.valoare)) FROM studenti
- *
- ERROR AT line 1:
- ORA-00937: NOT a single-GROUP GROUP FUNCTION
- SQL> SELECT studenti.an, studenti.grupa, AVG(note.valoare), MIN(AVG(note.valoare)) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 4
- SQL>
- SQL>
- SQL> SELECT MIN(AVG(note.valoare)) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa;
- MIN(AVG(NOTE.VALOARE))
- ----------------------
- 6.33333333
- SQL> SELECT AVG(note.valoare) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa
- 4 HAVING AVG(note.valoare) = MIN(AVG(note.valoare));
- HAVING AVG(note.valoare) = MIN(AVG(note.valoare))
- *
- ERROR AT line 4:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT MIN(AVG(note.valoare)) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa;
- MIN(AVG(NOTE.VALOARE))
- ----------------------
- 6.33333333
- SQL> SELECT studenti.an, studenti.grupa, MIN(AVG(note.valoare)) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa;
- SELECT studenti.an, studenti.grupa, MIN(AVG(note.valoare)) FROM studenti
- *
- ERROR AT line 1:
- ORA-00937: NOT a single-GROUP GROUP FUNCTION
- SQL> SELECT studenti.an, studenti.grupa, MIN(AVG(note.valoare)) FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.an, studenti.grupa, AVG(note.valoare);
- GROUP BY studenti.an, studenti.grupa, AVG(note.valoare)
- *
- ERROR AT line 3:
- ORA-00934: GROUP FUNCTION IS NOT allowed here
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.an, studenti.grupa
- 4 HAVING AVG(note.valoare) =
- 5 (
- 6 SELECT MIN(AVG(note.valoare)) FROM studenti
- 7 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 8 GROUP BY studenti.an, studenti.grupa
- 9 )
- 10 ;
- NUME PRENUME
- ---------- ----------
- Arhire Raluca
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- 4 HAVING AVG(note.valoare) =
- 5 (
- 6 SELECT MIN(AVG(note.valoare)) FROM studenti
- 7 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 8 GROUP BY studenti.an, studenti.grupa
- 9 )
- 10 ;
- NUME PRENUME
- ---------- ----------
- Arhire Raluca
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- 4 HAVING AVG(note.valoare) =
- 5 (
- 6 SELECT MIN(AVG(note.valoare)) FROM studenti
- 7 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 8 GROUP BY studenti.an, studenti.grupa
- 9 )
- 10 ;
- NUME PRENUME
- ---------- ----------
- Arhire Raluca
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti
- 2 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 3 GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.an, studenti.grupa
- 4 HAVING (studenti.an, studenti.grupa)
- 5 IN
- 6 (
- 7 SELECT studenti.an, studenti.grupa FROM studenti
- 8 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 9 GROUP BY studenti.an, studenti.grupa
- 10 HAVING AVG(note.valoare) =
- 11 (
- 12 SELECT MIN(AVG(note.valoare)) FROM studenti
- 13 JOIN note ON note.nr_matricol = studenti.nr_matricol
- 14 GROUP BY studenti.an, studenti.grupa
- 15 )
- 16 )
- 17 ;
- NUME PRENUME
- ---------- ----------
- Arhire Raluca
- SQL> SELECT * FROM studenti ORDER BY an, grupa ASC
- 2
- SQL> SELECT * FROM studenti ORDER BY an, grupa ASC;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 122 Cobzaru George 1 B1 350 29-APR-97
- 121 Arhire Alexandra 1 B1 02-JUL-97
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 123 Bucur Andreea 1 B2 10-MAY-97
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 114 Arhire Raluca 3 A4 26-DEC-95
- 115 Panaite Alexandru 3 B3 13-APR-95
- 13 ROWS selected.
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an;
- COUNT(*)
- ----------
- 4
- 4
- 5
- SQL> SELECT an,COUNT(*) FROM studenti GROUP BY an;
- AN COUNT(*)
- ---------- ----------
- 1 4
- 2 4
- 3 5
- SQL> SELECT an FROM studenti GROUP BY an HAVING MAX(COUNT(*));
- SELECT an FROM studenti GROUP BY an HAVING MAX(COUNT(*))
- *
- ERROR AT line 1:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT an FROM studenti GROUP BY an;
- AN
- ----------
- 1
- 2
- 3
- SQL> SELECT an FROM studenti GROUP BY an HAVING COUNT = MAX(SELECT ;
- SELECT an FROM studenti GROUP BY an HAVING COUNT = MAX(SELECT
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL>
- SQL>
- SQL> SELECT an FROM studenti GROUP BY an HAVING COUNT(*) = MAX(SELECT COUNT(*) FROM studenti GROUP BY an);
- SELECT an FROM studenti GROUP BY an HAVING COUNT(*) = MAX(SELECT COUNT(*) FROM studenti GROUP BY an)
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT an,COUNT(*) FROM studenti GROUP BY an;
- AN COUNT(*)
- ---------- ----------
- 1 4
- 2 4
- 3 5
- SQL> SELECT an, MAX(COUNT(*)) FROM studenti GROUP BY an;
- SELECT an, MAX(COUNT(*)) FROM studenti GROUP BY an
- *
- ERROR AT line 1:
- ORA-00937: NOT a single-GROUP GROUP FUNCTION
- SQL> SELECT an,COUNT(*) FROM studenti GROUP BY an;
- AN COUNT(*)
- ---------- ----------
- 1 4
- 2 4
- 3 5
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an;
- COUNT(*)
- ----------
- 4
- 4
- 5
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an HAVING MAX(COUNT(*));
- SELECT COUNT(*) FROM studenti GROUP BY an HAVING MAX(COUNT(*))
- *
- ERROR AT line 1:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an HAVING COUNT(*);
- SELECT COUNT(*) FROM studenti GROUP BY an HAVING COUNT(*)
- *
- ERROR AT line 1:
- ORA-00920: invalid relational OPERATOR
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an HAVING COUNT();
- SELECT COUNT(*) FROM studenti GROUP BY an HAVING COUNT()
- *
- ERROR AT line 1:
- ORA-00909: invalid NUMBER OF arguments
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY DESC;
- SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY DESC
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC;
- COUNT(*)
- ----------
- 5
- 4
- 4
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC ROWNUM=1;
- SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC ROWNUM=1
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL> SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC ROWNUM=1;
- SELECT COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC ROWNUM=1
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL>
- SQL> SELECT nume, prenume FROM studenti
- 2 WHERE an = (
- 3 SELECT an FROM (SELECT an, COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM = 1;
- SELECT an FROM (SELECT an, COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM = 1
- *
- ERROR AT line 3:
- ORA-00921: unexpected END OF SQL command
- SQL> );
- SP2-0042: unknown command ")" - rest OF line ignored.
- SQL>
- SQL> SELECT nume, prenume FROM studenti
- 2 WHERE an = (
- 3 SELECT an FROM (SELECT an, COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM = 1
- 4 );
- NUME PRENUME
- ---------- ----------
- Popescu Bogdan
- Prelipcean Radu
- Antonie Ioana
- Arhire Raluca
- Panaite Alexandru
- SQL> );SELECT nume, prenume, an FROM studenti
- SP2-0734: unknown command beginning ");select n..." - rest OF line ignored.
- SQL> WHERE an = (
- SP2-0734: unknown command beginning "WHERE an =..." - rest OF line ignored.
- SQL> SELECT an FROM (SELECT an, COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM = 1
- 2 );
- )
- *
- ERROR AT line 2:
- ORA-00933: SQL command NOT properly ended
- SQL> SELECT nume, prenume, an FROM studenti
- 2 WHERE an = (
- 3 SELECT an FROM (SELECT an, COUNT(*) FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM = 1
- 4 );
- NUME PRENUME AN
- ---------- ---------- ----------
- Popescu Bogdan 3
- Prelipcean Radu 3
- Antonie Ioana 3
- Arhire Raluca 3
- Panaite Alexandru 3
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, student.prenume;
- SELECT studenti.nume, studenti.prenume FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, student.prenume
- *
- ERROR AT line 1:
- ORA-00904: "STUDENT"."PRENUME": invalid identifier
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume;
- SELECT studenti.nume, studenti.prenume FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.prenume
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.nume, studenti.prenume FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume;
- NUME PRENUME
- ---------- ----------
- Popescu Bogdan
- Ciobotariu Ciprian
- Panaite Alexandru
- Bodnar Ioana
- Arhire Raluca
- Antonie Ioana
- Prelipcean Radu
- Archip Andrada
- Bodnar Ioana
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume;
- NUME PRENUME COUNT(NOTE.VALOARE)
- ---------- ---------- -------------------
- Popescu Bogdan 6
- Ciobotariu Ciprian 3
- Panaite Alexandru 6
- Bodnar Ioana 3
- Arhire Raluca 6
- Antonie Ioana 6
- Prelipcean Radu 6
- Archip Andrada 3
- Bodnar Ioana 3
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC;
- NUME PRENUME COUNT(NOTE.VALOARE)
- ---------- ---------- -------------------
- Popescu Bogdan 6
- Arhire Raluca 6
- Prelipcean Radu 6
- Antonie Ioana 6
- Panaite Alexandru 6
- Bodnar Ioana 3
- Bodnar Ioana 3
- Archip Andrada 3
- Ciobotariu Ciprian 3
- 9 ROWS selected.
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC studenti.nume ASC;
- SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC studenti.nume ASC
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC AND studenti.nume ASC;
- SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC AND studenti.nume ASC
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC;
- NUME PRENUME COUNT(NOTE.VALOARE)
- ---------- ---------- -------------------
- Antonie Ioana 6
- Arhire Raluca 6
- Panaite Alexandru 6
- Popescu Bogdan 6
- Prelipcean Radu 6
- Archip Andrada 3
- Bodnar Ioana 3
- Bodnar Ioana 3
- Ciobotariu Ciprian 3
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC;
- NUME PRENUME COUNT(NOTE.VALOARE)
- ---------- ---------- -------------------
- Popescu Bogdan 6
- Arhire Raluca 6
- Prelipcean Radu 6
- Antonie Ioana 6
- Panaite Alexandru 6
- Bodnar Ioana 3
- Bodnar Ioana 3
- Archip Andrada 3
- Ciobotariu Ciprian 3
- 9 ROWS selected.
- SQL>
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<6;
- NUME PRENUME COUNT(NOTE.VALOARE)
- ---------- ---------- -------------------
- Antonie Ioana 6
- Arhire Raluca 6
- Panaite Alexandru 6
- Popescu Bogdan 6
- Prelipcean Radu 6
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, note.valoare, note.id_curs FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<6;
- SELECT * FROM (SELECT studenti.nume, studenti.prenume, note.valoare, note.id_curs FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<6
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, note.valoare, note.id_curs FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<6;
- NUME PRENUME VALOARE ID
- ---------- ---------- ---------- --
- Antonie Ioana 10 24
- Antonie Ioana 7 23
- Antonie Ioana 9 21
- Antonie Ioana 9 22
- Antonie Ioana 4 25
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, note.valoare, note.id_curs FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC);
- NUME PRENUME VALOARE ID
- ---------- ---------- ---------- --
- Antonie Ioana 9 21
- Antonie Ioana 9 22
- Antonie Ioana 4 25
- Antonie Ioana 7 26
- Antonie Ioana 7 23
- Antonie Ioana 10 24
- Archip Andrada 4 23
- Archip Andrada 7 21
- Archip Andrada 6 22
- Arhire Raluca 4 26
- Arhire Raluca 10 23
- NUME PRENUME VALOARE ID
- ---------- ---------- ---------- --
- Arhire Raluca 5 25
- Arhire Raluca 6 21
- Arhire Raluca 9 22
- Arhire Raluca 4 24
- Bodnar Ioana 8 22
- Bodnar Ioana 9 23
- Bodnar Ioana 10 21
- Bodnar Ioana 7 21
- Bodnar Ioana 10 22
- Bodnar Ioana 9 23
- Ciobotariu Ciprian 7 22
- NUME PRENUME VALOARE ID
- ---------- ---------- ---------- --
- Ciobotariu Ciprian 7 21
- Ciobotariu Ciprian 7 23
- Panaite Alexandru 8 25
- Panaite Alexandru 10 23
- Panaite Alexandru 7 22
- Panaite Alexandru 10 24
- Panaite Alexandru 10 21
- Panaite Alexandru 9 26
- Popescu Bogdan 9 22
- Popescu Bogdan 10 23
- Popescu Bogdan 9 24
- NUME PRENUME VALOARE ID
- ---------- ---------- ---------- --
- Popescu Bogdan 7 25
- Popescu Bogdan 8 26
- Popescu Bogdan 8 21
- Prelipcean Radu 6 24
- Prelipcean Radu 6 22
- Prelipcean Radu 7 25
- Prelipcean Radu 7 21
- Prelipcean Radu 5 23
- Prelipcean Radu 4 26
- 42 ROWS selected.
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, COUNT(note.valoare), note.valoare, note.id_curs FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC);
- NUME PRENUME COUNT(NOTE.VALOARE) VALOARE ID
- ---------- ---------- ------------------- ---------- --
- Antonie Ioana 1 9 21
- Antonie Ioana 1 9 22
- Antonie Ioana 1 4 25
- Antonie Ioana 1 7 26
- Antonie Ioana 1 7 23
- Antonie Ioana 1 10 24
- Archip Andrada 1 4 23
- Archip Andrada 1 7 21
- Archip Andrada 1 6 22
- Arhire Raluca 1 4 26
- Arhire Raluca 1 10 23
- NUME PRENUME COUNT(NOTE.VALOARE) VALOARE ID
- ---------- ---------- ------------------- ---------- --
- Arhire Raluca 1 5 25
- Arhire Raluca 1 6 21
- Arhire Raluca 1 9 22
- Arhire Raluca 1 4 24
- Bodnar Ioana 1 8 22
- Bodnar Ioana 1 9 23
- Bodnar Ioana 1 10 21
- Bodnar Ioana 1 7 21
- Bodnar Ioana 1 10 22
- Bodnar Ioana 1 9 23
- Ciobotariu Ciprian 1 7 22
- NUME PRENUME COUNT(NOTE.VALOARE) VALOARE ID
- ---------- ---------- ------------------- ---------- --
- Ciobotariu Ciprian 1 7 21
- Ciobotariu Ciprian 1 7 23
- Panaite Alexandru 1 8 25
- Panaite Alexandru 1 10 23
- Panaite Alexandru 1 7 22
- Panaite Alexandru 1 10 24
- Panaite Alexandru 1 10 21
- Panaite Alexandru 1 9 26
- Popescu Bogdan 1 9 22
- Popescu Bogdan 1 10 23
- Popescu Bogdan 1 9 24
- NUME PRENUME COUNT(NOTE.VALOARE) VALOARE ID
- ---------- ---------- ------------------- ---------- --
- Popescu Bogdan 1 7 25
- Popescu Bogdan 1 8 26
- Popescu Bogdan 1 8 21
- Prelipcean Radu 1 6 24
- Prelipcean Radu 1 6 22
- Prelipcean Radu 1 7 25
- Prelipcean Radu 1 7 21
- Prelipcean Radu 1 5 23
- Prelipcean Radu 1 4 26
- 42 ROWS selected.
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, COUNT(note.valoare), note.id_curs FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC);
- NUME PRENUME COUNT(NOTE.VALOARE) ID
- ---------- ---------- ------------------- --
- Antonie Ioana 1 21
- Antonie Ioana 1 22
- Antonie Ioana 1 25
- Antonie Ioana 1 26
- Antonie Ioana 1 23
- Antonie Ioana 1 24
- Archip Andrada 1 23
- Archip Andrada 1 21
- Archip Andrada 1 22
- Arhire Raluca 1 26
- Arhire Raluca 1 23
- NUME PRENUME COUNT(NOTE.VALOARE) ID
- ---------- ---------- ------------------- --
- Arhire Raluca 1 25
- Arhire Raluca 1 21
- Arhire Raluca 1 22
- Arhire Raluca 1 24
- Bodnar Ioana 1 22
- Bodnar Ioana 1 23
- Bodnar Ioana 1 21
- Bodnar Ioana 1 21
- Bodnar Ioana 1 22
- Bodnar Ioana 1 23
- Ciobotariu Ciprian 1 22
- NUME PRENUME COUNT(NOTE.VALOARE) ID
- ---------- ---------- ------------------- --
- Ciobotariu Ciprian 1 21
- Ciobotariu Ciprian 1 23
- Panaite Alexandru 1 25
- Panaite Alexandru 1 23
- Panaite Alexandru 1 22
- Panaite Alexandru 1 24
- Panaite Alexandru 1 21
- Panaite Alexandru 1 26
- Popescu Bogdan 1 22
- Popescu Bogdan 1 23
- Popescu Bogdan 1 24
- NUME PRENUME COUNT(NOTE.VALOARE) ID
- ---------- ---------- ------------------- --
- Popescu Bogdan 1 25
- Popescu Bogdan 1 26
- Popescu Bogdan 1 21
- Prelipcean Radu 1 24
- Prelipcean Radu 1 22
- Prelipcean Radu 1 25
- Prelipcean Radu 1 21
- Prelipcean Radu 1 23
- Prelipcean Radu 1 26
- 42 ROWS selected.
- SQL>
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, COUNT(note.valoare)"NrCursuri" FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<=5;
- NUME PRENUME NrCursuri
- ---------- ---------- ----------
- Antonie Ioana 1
- Antonie Ioana 1
- Antonie Ioana 1
- Antonie Ioana 1
- Antonie Ioana 1
- SQL>
- SQL>
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, COUNT(note.valoare)"NrCursuri" FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<=5;
- NUME PRENUME NrCursuri
- ---------- ---------- ----------
- Antonie Ioana 1
- Antonie Ioana 1
- Antonie Ioana 1
- Antonie Ioana 1
- Antonie Ioana 1
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, COUNT(note.valoare) FROM studenti RIGHT JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY COUNT(note.valoare) DESC, studenti.nume ASC) WHERE ROWNUM<6;
- NUME PRENUME COUNT(NOTE.VALOARE)
- ---------- ---------- -------------------
- Antonie Ioana 6
- Arhire Raluca 6
- Panaite Alexandru 6
- Popescu Bogdan 6
- Prelipcean Radu 6
- SQL> SELECT valoare FROM note WHERE valoare<5
- 2
- SQL> SELECT valoare FROM note WHERE valoare<5;
- VALOARE
- ----------
- 4
- 4
- 4
- 4
- 4
- SQL> SELECT studenti.nume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE valoare<5;
- NUME VALOARE
- ---------- ----------
- Prelipcean 4
- Antonie 4
- Arhire 4
- Arhire 4
- Archip 4
- SQL> SELECT studenti.nume, studenti.grupa, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE valoare<5;
- NUME GR VALOARE
- ---------- -- ----------
- Prelipcean A2 4
- Antonie A2 4
- Arhire A4 4
- Arhire A4 4
- Archip A1 4
- SQL> SELECT studenti.grupa, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE valoare<5;
- GR VALOARE
- -- ----------
- A2 4
- A2 4
- A4 4
- A4 4
- A1 4
- SQL> SELECT studenti.grupa, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa;
- SELECT studenti.grupa, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.grupa, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare;
- GR VALOARE
- -- ----------
- A2 7
- A4 4
- A1 6
- A1 10
- A2 6
- A1 9
- B2 7
- A2 5
- B3 10
- B2 8
- A2 10
- GR VALOARE
- -- ----------
- A4 9
- A4 10
- B3 8
- B2 9
- A2 8
- A2 9
- A4 6
- A1 7
- A1 4
- A2 4
- A4 5
- GR VALOARE
- -- ----------
- B3 7
- B3 9
- 24 ROWS selected.
- SQL> SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa;
- GR
- --
- A2
- A4
- B3
- B2
- A1
- SQL> SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa HAVING note.valoare < 4;
- SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa HAVING note.valoare < 4
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 4;
- no ROWS selected
- SQL> SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 4;
- no ROWS selected
- SQL> SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5;
- GR
- --
- A4
- A1
- A2
- SQL> SELECT studenti.grupa, COUNT(*) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5;
- GR COUNT(*)
- -- ----------
- A4 2
- A1 1
- A2 2
- SQL> SELECT studenti.grupa, COUNT(*) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5;
- GR COUNT(*)
- -- ----------
- A4 2
- A1 1
- A2 2
- SQL> SELECT studenti.an, studenti.grupa, COUNT(*) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5;
- AN GR COUNT(*)
- ---------- -- ----------
- 3 A4 2
- 2 A1 1
- 3 A2 2
- SQL> SELECT studenti.grupa, COUNT(*) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5;
- GR COUNT(*)
- -- ----------
- A4 2
- A1 1
- A2 2
- SQL> SELECT studenti.grupa, COUNT(*) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC;
- GR COUNT(*)
- -- ----------
- A1 1
- A2 2
- A4 2
- SQL> SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC;
- GR
- --
- A1
- A2
- A4
- SQL> SELECT * FROM
- 2 (SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC;)
- 3 WHERE ROWNUM=1;
- (SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC;)
- *
- ERROR AT line 2:
- ORA-00911: invalid character
- SQL> WHERE ROWNUM=1;
- SP2-0734: unknown command beginning "WHERE ROWN..." - rest OF line ignored.
- SQL>
- SQL>
- SQL> SELECT * FROM
- 2 (SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC;)
- 3 WHERE ROWNUM=1;
- (SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC;)
- *
- ERROR AT line 2:
- ORA-00911: invalid character
- SQL> SELECT * FROM
- 2 (SELECT studenti.grupa FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.an, studenti.grupa, note.valoare HAVING note.valoare < 5 ORDER BY COUNT(*) ASC)
- 3 WHERE ROWNUM=1;
- GR
- --
- A1
- SQL> SELECT studenti.an, studenti.grupa, studenti.nr_matricol, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol;
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 3 A2 111 8
- 3 A2 111 9
- 3 A2 111 10
- 3 A2 111 9
- 3 A2 111 7
- 3 A2 111 8
- 3 A2 112 7
- 3 A2 112 6
- 3 A2 112 5
- 3 A2 112 6
- 3 A2 112 7
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 3 A2 112 4
- 3 A2 113 9
- 3 A2 113 9
- 3 A2 113 7
- 3 A2 113 10
- 3 A2 113 4
- 3 A2 113 7
- 3 A4 114 6
- 3 A4 114 9
- 3 A4 114 10
- 3 A4 114 4
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 3 A4 114 5
- 3 A4 114 4
- 3 B3 115 10
- 3 B3 115 7
- 3 B3 115 10
- 3 B3 115 10
- 3 B3 115 8
- 3 B3 115 9
- 2 A1 116 10
- 2 A1 116 10
- 2 A1 116 9
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 2 A1 117 7
- 2 A1 117 6
- 2 A1 117 4
- 2 A1 118 7
- 2 A1 118 7
- 2 A1 118 7
- 2 B2 119 7
- 2 B2 119 8
- 2 B2 119 9
- 42 ROWS selected.
- SQL> SELECT studenti.an, studenti.grupa, studenti.nr_matricol, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol ORDER BY studenti.an ASC, studenti.grupa ASC, studenti.nr_matricol ASC;
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 2 A1 116 10
- 2 A1 116 10
- 2 A1 116 9
- 2 A1 117 7
- 2 A1 117 6
- 2 A1 117 4
- 2 A1 118 7
- 2 A1 118 7
- 2 A1 118 7
- 2 B2 119 7
- 2 B2 119 8
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 2 B2 119 9
- 3 A2 111 8
- 3 A2 111 7
- 3 A2 111 9
- 3 A2 111 10
- 3 A2 111 8
- 3 A2 111 9
- 3 A2 112 7
- 3 A2 112 6
- 3 A2 112 5
- 3 A2 112 6
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 3 A2 112 7
- 3 A2 112 4
- 3 A2 113 4
- 3 A2 113 10
- 3 A2 113 7
- 3 A2 113 9
- 3 A2 113 9
- 3 A2 113 7
- 3 A4 114 4
- 3 A4 114 5
- 3 A4 114 4
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 3 A4 114 10
- 3 A4 114 6
- 3 A4 114 9
- 3 B3 115 8
- 3 B3 115 10
- 3 B3 115 10
- 3 B3 115 7
- 3 B3 115 10
- 3 B3 115 9
- 42 ROWS selected.
- SQL> SELECT studenti.an, studenti.grupa, studenti.nr_matricol, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol ORDER BY studenti.an ASC, studenti.grupa ASC, studenti.nr_matricol ASC WHERE note.valoare <5;
- SELECT studenti.an, studenti.grupa, studenti.nr_matricol, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol ORDER BY studenti.an ASC, studenti.grupa ASC, studenti.nr_matricol ASC WHERE note.valoare <5
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL> SELECT studenti.an, studenti.grupa, studenti.nr_matricol, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE note.valoare < 5 ORDER BY studenti.an ASC, studenti.grupa ASC, studenti.nr_matricol ASC;
- AN GR NR_M VALOARE
- ---------- -- ---- ----------
- 2 A1 117 4
- 3 A2 112 4
- 3 A2 113 4
- 3 A4 114 4
- 3 A4 114 4
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- Antonie Ioana 7.66666667
- Bodnar Ioana 8
- Popescu Bogdan 8.5
- Panaite Alexandru 9
- Bodnar Ioana 9.66666667
- 9 ROWS selected.
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4;
- no ROWS selected
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM <> 1;
- no ROWS selected
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM <> 2;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM <> 3;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM <> 4;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM <> 4SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY * DESC;;
- SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM <> 4SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY * DESC;
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY * DESC;
- SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY * DESC
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY av DESC;
- SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY av DESC
- *
- ERROR AT line 1:
- ORA-00904: "AV": invalid identifier
- SQL>
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY AVG(note.valoare) DESC;
- SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4 ORDER BY AVG(note.valoare) DESC
- *
- ERROR AT line 1:
- ORA-00904: "NOTE"."VALOARE": invalid identifier
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4;
- no ROWS selected
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM < 4;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM < 4;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- SQL> SELECT * FROM(SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM > 1 AND ROWNUM < 4;
- no ROWS selected
- SQL>
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM < 4;
- SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5) WHERE ROWNUM < 4
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 5;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 4;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- SQL> SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 4 ORDER BY AVG(note.valoare) DESC;
- SELECT * FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 4 ORDER BY AVG(note.valoare) DESC
- *
- ERROR AT line 1:
- ORA-00904: "NOTE"."VALOARE": invalid identifier
- SQL> SELECT * FROM (SELECT ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)) WHERE RN <> 1;
- RN
- ----------
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 8 ROWS selected.
- SQL>
- SQL> SELECT * FROM (SELECT ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)) WHERE RN <> 1 AND RN <4;
- RN
- ----------
- 2
- 3
- SQL> SELECT * FROM (SELECT *,ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)) WHERE RN <> 1 AND RN <4;
- SELECT * FROM (SELECT *,ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)) WHERE RN <> 1 AND RN <4
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT * FROM (SELECT totul,ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)"totul") WHERE RN <> 1 AND RN <4;
- SELECT * FROM (SELECT totul,ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)"totul") WHERE RN <> 1 AND RN <4
- *
- ERROR AT line 1:
- ORA-00904: "TOTUL": invalid identifier
- SQL> SELECT * FROM (SELECT totul,ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)AS "totul") WHERE RN <> 1 AND RN <4;
- SELECT * FROM (SELECT totul,ROWNUM AS"RN" FROM(SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC)AS "totul") WHERE RN <> 1 AND RN <4
- *
- ERROR AT line 1:
- ORA-00907: missing right parenthesis
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC
- 2
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- Antonie Ioana 7.66666667
- Bodnar Ioana 8
- Popescu Bogdan 8.5
- Panaite Alexandru 9
- Bodnar Ioana 9.66666667
- 9 ROWS selected.
- SQL> SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC;
- SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC;
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 22 Arhire Raluca 4
- 24 Arhire Raluca 4
- 12 Prelipcean Radu 4
- 36 Archip Andrada 4
- 17 Antonie Ioana 4
- 23 Arhire Raluca 5
- 9 Prelipcean Radu 5
- 35 Archip Andrada 6
- 19 Arhire Raluca 6
- 10 Prelipcean Radu 6
- 8 Prelipcean Radu 6
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 38 Ciobotariu Ciprian 7
- 15 Antonie Ioana 7
- 11 Prelipcean Radu 7
- 5 Popescu Bogdan 7
- 39 Ciobotariu Ciprian 7
- 34 Archip Andrada 7
- 26 Panaite Alexandru 7
- 7 Prelipcean Radu 7
- 40 Bodnar Ioana 7
- 37 Ciobotariu Ciprian 7
- 18 Antonie Ioana 7
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 29 Panaite Alexandru 8
- 6 Popescu Bogdan 8
- 41 Bodnar Ioana 8
- 1 Popescu Bogdan 8
- 4 Popescu Bogdan 9
- 13 Antonie Ioana 9
- 33 Bodnar Ioana 9
- 42 Bodnar Ioana 9
- 20 Arhire Raluca 9
- 2 Popescu Bogdan 9
- 30 Panaite Alexandru 9
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 14 Antonie Ioana 9
- 27 Panaite Alexandru 10
- 31 Bodnar Ioana 10
- 16 Antonie Ioana 10
- 25 Panaite Alexandru 10
- 28 Panaite Alexandru 10
- 21 Arhire Raluca 10
- 3 Popescu Bogdan 10
- 32 Bodnar Ioana 10
- 42 ROWS selected.
- SQL> SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC;
- SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT * FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC);
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 22 Arhire Raluca 4
- 24 Arhire Raluca 4
- 12 Prelipcean Radu 4
- 36 Archip Andrada 4
- 17 Antonie Ioana 4
- 23 Arhire Raluca 5
- 9 Prelipcean Radu 5
- 35 Archip Andrada 6
- 19 Arhire Raluca 6
- 10 Prelipcean Radu 6
- 8 Prelipcean Radu 6
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 38 Ciobotariu Ciprian 7
- 15 Antonie Ioana 7
- 11 Prelipcean Radu 7
- 5 Popescu Bogdan 7
- 39 Ciobotariu Ciprian 7
- 34 Archip Andrada 7
- 26 Panaite Alexandru 7
- 7 Prelipcean Radu 7
- 40 Bodnar Ioana 7
- 37 Ciobotariu Ciprian 7
- 18 Antonie Ioana 7
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 29 Panaite Alexandru 8
- 6 Popescu Bogdan 8
- 41 Bodnar Ioana 8
- 1 Popescu Bogdan 8
- 4 Popescu Bogdan 9
- 13 Antonie Ioana 9
- 33 Bodnar Ioana 9
- 42 Bodnar Ioana 9
- 20 Arhire Raluca 9
- 2 Popescu Bogdan 9
- 30 Panaite Alexandru 9
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 14 Antonie Ioana 9
- 27 Panaite Alexandru 10
- 31 Bodnar Ioana 10
- 16 Antonie Ioana 10
- 25 Panaite Alexandru 10
- 28 Panaite Alexandru 10
- 21 Arhire Raluca 10
- 3 Popescu Bogdan 10
- 32 Bodnar Ioana 10
- 42 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC);
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC)
- *
- ERROR AT line 1:
- ORA-00904: "NOTE"."VALOARE": invalid identifier
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC) GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume;
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC) GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- *
- ERROR AT line 1:
- ORA-00904: "STUDENTI"."PRENUME": invalid identifier
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC);
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC)
- *
- ERROR AT line 1:
- ORA-00904: "NOTE"."VALOARE": invalid identifier
- SQL> SELECT * FROM (SELECT ROWNUM R, studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, ROWNUM ORDER BY AVG(note.valoare) ASC);
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 22 Arhire Raluca 4
- 24 Arhire Raluca 4
- 12 Prelipcean Radu 4
- 36 Archip Andrada 4
- 17 Antonie Ioana 4
- 23 Arhire Raluca 5
- 9 Prelipcean Radu 5
- 35 Archip Andrada 6
- 19 Arhire Raluca 6
- 10 Prelipcean Radu 6
- 8 Prelipcean Radu 6
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 38 Ciobotariu Ciprian 7
- 15 Antonie Ioana 7
- 11 Prelipcean Radu 7
- 5 Popescu Bogdan 7
- 39 Ciobotariu Ciprian 7
- 34 Archip Andrada 7
- 26 Panaite Alexandru 7
- 7 Prelipcean Radu 7
- 40 Bodnar Ioana 7
- 37 Ciobotariu Ciprian 7
- 18 Antonie Ioana 7
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 29 Panaite Alexandru 8
- 6 Popescu Bogdan 8
- 41 Bodnar Ioana 8
- 1 Popescu Bogdan 8
- 4 Popescu Bogdan 9
- 13 Antonie Ioana 9
- 33 Bodnar Ioana 9
- 42 Bodnar Ioana 9
- 20 Arhire Raluca 9
- 2 Popescu Bogdan 9
- 30 Panaite Alexandru 9
- R NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- ---------- -----------------
- 14 Antonie Ioana 9
- 27 Panaite Alexandru 10
- 31 Bodnar Ioana 10
- 16 Antonie Ioana 10
- 25 Panaite Alexandru 10
- 28 Panaite Alexandru 10
- 21 Arhire Raluca 10
- 3 Popescu Bogdan 10
- 32 Bodnar Ioana 10
- 42 ROWS selected.
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC);
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- Antonie Ioana 7.66666667
- Bodnar Ioana 8
- Popescu Bogdan 8.5
- Panaite Alexandru 9
- Bodnar Ioana 9.66666667
- 9 ROWS selected.
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC);
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- Ciobotariu Ciprian 7
- Antonie Ioana 7.66666667
- Bodnar Ioana 8
- Popescu Bogdan 8.5
- Panaite Alexandru 9
- Bodnar Ioana 9.66666667
- 9 ROWS selected.
- SQL>
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 4;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- Prelipcean Radu 5.83333333
- Arhire Raluca 6.33333333
- SQL> MINUS
- SP2-0042: unknown command "MINUS" - rest OF line ignored.
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM = 1;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Archip Andrada 5.66666667
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM < 4
- 2 MINUS
- 3 SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume ORDER BY AVG(note.valoare) ASC) WHERE ROWNUM = 1;
- NUME PRENUME AVG(NOTE.VALOARE)
- ---------- ---------- -----------------
- Arhire Raluca 6.33333333
- Prelipcean Radu 5.83333333
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER=2;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Prelipcean Radu 5.83333333 2
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER<>1;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Prelipcean Radu 5.83333333 2
- Arhire Raluca 6.33333333 3
- Ciobotariu Ciprian 7 4
- Antonie Ioana 7.66666667 5
- Bodnar Ioana 8 6
- Popescu Bogdan 8.5 7
- Panaite Alexandru 9 8
- Bodnar Ioana 9.66666667 9
- 8 ROWS selected.
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER=2 AND ROW_NUMBER=3;
- no ROWS selected
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER>1 AND ROW_NUMBER<=3;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Prelipcean Radu 5.83333333 2
- Arhire Raluca 6.33333333 3
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER>1 AND ROW_NUMBER<=3;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Prelipcean Radu 5.83333333 2
- Arhire Raluca 6.33333333 3
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 1 AND 4
- 2
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 1 AND 4;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Archip Andrada 5.66666667 1
- Prelipcean Radu 5.83333333 2
- Arhire Raluca 6.33333333 3
- Ciobotariu Ciprian 7 4
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Prelipcean Radu 5.83333333 2
- Arhire Raluca 6.33333333 3
- SQL> SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3;
- NUME PRENUME AVG(NOTE.VALOARE) ROW_NUMBER
- ---------- ---------- ----------------- ----------
- Prelipcean Radu 5.83333333 2
- Arhire Raluca 6.33333333 3
- SQL> .
- SQL>
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3);
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3)
- *
- ERROR AT line 1:
- ORA-00904: "NOTE"."VALOARE": invalid identifier
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3) JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume);
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3) JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume)
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3) JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume;
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3) JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- *
- ERROR AT line 1:
- ORA-00904: "STUDENTI"."NR_MATRICOL": invalid identifier
- SQL> SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3) JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nume, studenti.prenume;
- SELECT studenti.nume, studenti.prenume, AVG(note.valoare) FROM (SELECT * FROM (SELECT studenti.nume, studenti.prenume, AVG(note.valoare), ROW_NUMBER() OVER (ORDER BY AVG(note.valoare) ASC) AS ROW_NUMBER FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume) WHERE ROW_NUMBER BETWEEN 2 AND 3) JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nume, studenti.prenume
- *
- ERROR AT line 1:
- ORA-00904: "STUDENTI"."NR_MATRICOL": invalid identifier
- SQL>
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare;
- NUME PRENUME VALOARE
- ---------- ---------- ----------
- Popescu Bogdan 9
- Panaite Alexandru 9
- Arhire Raluca 6
- Panaite Alexandru 8
- Antonie Ioana 7
- Antonie Ioana 10
- Arhire Raluca 9
- Bodnar Ioana 10
- Bodnar Ioana 8
- Prelipcean Radu 4
- Antonie Ioana 9
- NUME PRENUME VALOARE
- ---------- ---------- ----------
- Popescu Bogdan 8
- Popescu Bogdan 10
- Prelipcean Radu 5
- Arhire Raluca 10
- Arhire Raluca 4
- Archip Andrada 7
- Ciobotariu Ciprian 7
- Bodnar Ioana 9
- Popescu Bogdan 7
- Prelipcean Radu 7
- Prelipcean Radu 6
- NUME PRENUME VALOARE
- ---------- ---------- ----------
- Antonie Ioana 4
- Arhire Raluca 5
- Panaite Alexandru 7
- Archip Andrada 6
- Bodnar Ioana 9
- Bodnar Ioana 7
- Panaite Alexandru 10
- Archip Andrada 4
- 30 ROWS selected.
- SQL> SELECT * FROM cursuri;
- ID TITLU_CURS AN SEMESTRU CREDITE
- -- --------------- ---------- ---------- ----------
- 21 Logica 1 1 5
- 22 Matematica 1 1 4
- 23 OOP 1 2 5
- 24 BD 2 1 8
- 25 JAVA 2 2 5
- 26 Tehnologii Web 2 2 5
- 27 Sec. Info. 3 1 5
- 28 DSFUM 3 1 6
- 29 Limbaje formale 2 1 5
- 9 ROWS selected.
- SQL> SELECT * FROM didactic;
- ID_P ID_C
- ---- ----
- p1 21
- p9 21
- p5 22
- p3 23
- p6 24
- p7 24
- p8 25
- p2 26
- p4 27
- p7 28
- 10 ROWS selected.
- SQL> SELECT * FROM note
- 2
- SQL> SELECT * FROM note;
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 111 21 8 17-FEB-14
- 111 22 9 19-FEB-14
- 111 23 10 24-JUN-14
- 111 24 9 17-FEB-15
- 111 25 7 20-JUN-15
- 111 26 8 21-JUN-15
- 112 21 7 25-FEB-14
- 112 22 6 19-FEB-14
- 112 23 5 24-JUN-14
- 112 24 6 17-FEB-15
- 112 25 7 20-JUN-15
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 112 26 4 21-JUN-15
- 113 21 9 17-FEB-14
- 113 22 9 19-FEB-14
- 113 23 7 24-JUN-14
- 113 24 10 17-FEB-15
- 113 25 4 20-JUN-15
- 113 26 7 21-JUN-15
- 114 21 6 17-FEB-14
- 114 22 9 19-FEB-14
- 114 23 10 24-JUN-14
- 114 24 4 17-FEB-15
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 114 25 5 20-JUN-15
- 114 26 4 21-JUN-15
- 115 21 10 17-FEB-14
- 115 22 7 19-FEB-14
- 115 23 10 24-JUN-14
- 115 24 10 17-FEB-15
- 115 25 8 20-JUN-15
- 115 26 9 21-JUN-15
- 116 21 10 18-FEB-15
- 116 22 10 20-FEB-15
- 116 23 9 21-JUN-15
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 117 21 7 18-FEB-15
- 117 22 6 20-FEB-15
- 117 23 4 25-JUN-15
- 118 21 7 22-FEB-15
- 118 22 7 24-FEB-15
- 118 23 7 21-JUN-15
- 119 21 7 18-FEB-15
- 119 22 8 20-FEB-15
- 119 23 9 21-JUN-15
- 42 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare HAVING note.id_curs=23;
- SELECT studenti.nume, studenti.prenume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare HAVING note.id_curs=23
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23;
- NUME PRENUME VALOARE
- ---------- ---------- ----------
- Prelipcean Radu 5
- Bodnar Ioana 9
- Popescu Bogdan 10
- Antonie Ioana 7
- Arhire Raluca 10
- Bodnar Ioana 9
- Ciobotariu Ciprian 7
- Panaite Alexandru 10
- Archip Andrada 4
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23 AND note.valoare > (SELECT AVG(valoare) FROM note WHERE id_curs=23 GROUP BY id_curs);
- NUME PRENUME VALOARE
- ---------- ---------- ----------
- Bodnar Ioana 9
- Popescu Bogdan 10
- Arhire Raluca 10
- Bodnar Ioana 9
- Panaite Alexandru 10
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare"OOP" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23 AND note.valoare > (SELECT AVG(valoare) FROM note WHERE id_curs=23 GROUP BY id_curs) ORDER BY prenume DESC;
- NUME PRENUME OOP
- ---------- ---------- ----------
- Arhire Raluca 10
- Bodnar Ioana 9
- Bodnar Ioana 9
- Popescu Bogdan 10
- Panaite Alexandru 10
- SQL> SELECT AVG(valoare) FROM note WHERE id_curs=23 GROUP BY id_curs
- 2
- SQL> SELECT AVG(valoare) FROM note WHERE id_curs=23 GROUP BY id_curs;
- AVG(VALOARE)
- ------------
- 7.88888889
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare"OOP" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23;
- NUME PRENUME OOP
- ---------- ---------- ----------
- Prelipcean Radu 5
- Bodnar Ioana 9
- Popescu Bogdan 10
- Antonie Ioana 7
- Arhire Raluca 10
- Bodnar Ioana 9
- Ciobotariu Ciprian 7
- Panaite Alexandru 10
- Archip Andrada 4
- 9 ROWS selected.
- SQL> SELECT studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare"OOP" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23;
- NR_M NUME PRENUME OOP
- ---- ---------- ---------- ----------
- 112 Prelipcean Radu 5
- 119 Bodnar Ioana 9
- 111 Popescu Bogdan 10
- 113 Antonie Ioana 7
- 114 Arhire Raluca 10
- 116 Bodnar Ioana 9
- 118 Ciobotariu Ciprian 7
- 115 Panaite Alexandru 10
- 117 Archip Andrada 4
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare"OOP" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23;
- NUME PRENUME OOP
- ---------- ---------- ----------
- Prelipcean Radu 5
- Bodnar Ioana 9
- Popescu Bogdan 10
- Antonie Ioana 7
- Arhire Raluca 10
- Bodnar Ioana 9
- Ciobotariu Ciprian 7
- Panaite Alexandru 10
- Archip Andrada 4
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23;
- NUME PRENUME VALOARE
- ---------- ---------- ----------
- Prelipcean Radu 5
- Bodnar Ioana 9
- Popescu Bogdan 10
- Antonie Ioana 7
- Arhire Raluca 10
- Bodnar Ioana 9
- Ciobotariu Ciprian 7
- Panaite Alexandru 10
- Archip Andrada 4
- 9 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume, note.valoare"OOP" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23 AND note.valoare > (SELECT AVG(valoare) FROM note WHERE id_curs=23 GROUP BY id_curs) ORDER BY prenume DESC;
- NUME PRENUME OOP
- ---------- ---------- ----------
- Arhire Raluca 10
- Bodnar Ioana 9
- Bodnar Ioana 9
- Popescu Bogdan 10
- Panaite Alexandru 10
- SQL> SELECT studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare"OOP" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, note.valoare, note.id_curs HAVING note.id_curs=23 AND note.valoare > (SELECT AVG(valoare) FROM note WHERE id_curs=23 GROUP BY id_curs) ORDER BY prenume DESC;
- NR_M NUME PRENUME OOP
- ---- ---------- ---------- ----------
- 114 Arhire Raluca 10
- 116 Bodnar Ioana 9
- 119 Bodnar Ioana 9
- 111 Popescu Bogdan 10
- 115 Panaite Alexandru 10
- SQL>
- SQL>
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs;
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Varlan Cosmin BD
- Breaban Mihaela BD
- Frasinaru Cristian JAVA
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Lucanu Dorel OOP
- Varlan Cosmin BD
- Breaban Mihaela BD
- Frasinaru Cristian JAVA
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Varlan Cosmin BD
- Breaban Mihaela BD
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Frasinaru Cristian JAVA
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Varlan Cosmin BD
- Breaban Mihaela BD
- Frasinaru Cristian JAVA
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Varlan Cosmin BD
- Breaban Mihaela BD
- Frasinaru Cristian JAVA
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Ciobaca Stefan Logica
- Masalagiu Cristian Logica
- Iacob Florin Matematica
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Lucanu Dorel OOP
- 56 ROWS selected.
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs ORDER BY nume ASC;
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Breaban Mihaela BD
- Breaban Mihaela BD
- Breaban Mihaela BD
- Breaban Mihaela BD
- Breaban Mihaela BD
- Buraga Sabin Tehnologii Web
- Buraga Sabin Tehnologii Web
- Buraga Sabin Tehnologii Web
- Buraga Sabin Tehnologii Web
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Ciobaca Stefan Logica
- Frasinaru Cristian JAVA
- Frasinaru Cristian JAVA
- Frasinaru Cristian JAVA
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Frasinaru Cristian JAVA
- Frasinaru Cristian JAVA
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- Iacob Florin Matematica
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Lucanu Dorel OOP
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- Masalagiu Cristian Logica
- Varlan Cosmin BD
- Varlan Cosmin BD
- Varlan Cosmin BD
- Varlan Cosmin BD
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Varlan Cosmin BD
- 56 ROWS selected.
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs ORDER BY nume ASC;
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Breaban Mihaela BD
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Frasinaru Cristian JAVA
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Masalagiu Cristian Logica
- Tiplea Laurentiu Sec. Info.
- Varlan Cosmin DSFUM
- Varlan Cosmin BD
- 10 ROWS selected.
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs ORDER BY nume ASC GROUP BY profesori.id_prof;
- SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs ORDER BY nume ASC GROUP BY profesori.id_prof
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY profesori.id_prof ORDER BY nume ASC ;
- SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY profesori.id_prof ORDER BY nume ASC
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY profesori.id_prof, profesori.nume, profesori.prenume ORDER BY nume ASC ;
- SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY profesori.id_prof, profesori.nume, profesori.prenume ORDER BY nume ASC
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs ORDER BY nume ASC ;
- SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs ORDER BY nume ASC
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.id_prof, profesori.nume, profesori.prenume ORDER BY nume ASC ;
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Breaban Mihaela BD
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Frasinaru Cristian JAVA
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Masalagiu Cristian Logica
- Varlan Cosmin BD
- 8 ROWS selected.
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof ORDER BY nume ASC ;
- NUME PRENUME TITLU_CURS
- ---------- ---------- ---------------
- Breaban Mihaela BD
- Buraga Sabin Tehnologii Web
- Ciobaca Stefan Logica
- Frasinaru Cristian JAVA
- Iacob Florin Matematica
- Lucanu Dorel OOP
- Masalagiu Cristian Logica
- Varlan Cosmin BD
- 8 ROWS selected.
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof, note.valoare ORDER BY nume ASC ;
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Breaban Mihaela BD 4
- Breaban Mihaela BD 6
- Breaban Mihaela BD 9
- Breaban Mihaela BD 10
- Buraga Sabin Tehnologii Web 4
- Buraga Sabin Tehnologii Web 7
- Buraga Sabin Tehnologii Web 8
- Buraga Sabin Tehnologii Web 9
- Ciobaca Stefan Logica 6
- Ciobaca Stefan Logica 7
- Ciobaca Stefan Logica 8
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Ciobaca Stefan Logica 9
- Ciobaca Stefan Logica 10
- Frasinaru Cristian JAVA 4
- Frasinaru Cristian JAVA 5
- Frasinaru Cristian JAVA 7
- Frasinaru Cristian JAVA 8
- Iacob Florin Matematica 6
- Iacob Florin Matematica 7
- Iacob Florin Matematica 8
- Iacob Florin Matematica 9
- Iacob Florin Matematica 10
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Lucanu Dorel OOP 4
- Lucanu Dorel OOP 5
- Lucanu Dorel OOP 7
- Lucanu Dorel OOP 9
- Lucanu Dorel OOP 10
- Masalagiu Cristian Logica 6
- Masalagiu Cristian Logica 7
- Masalagiu Cristian Logica 8
- Masalagiu Cristian Logica 9
- Masalagiu Cristian Logica 10
- Varlan Cosmin BD 4
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Varlan Cosmin BD 6
- Varlan Cosmin BD 9
- Varlan Cosmin BD 10
- 36 ROWS selected.
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof ORDER BY nume ASC ;
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Breaban Mihaela BD 7.8
- Buraga Sabin Tehnologii Web 6.4
- Ciobaca Stefan Logica 7.88888889
- Frasinaru Cristian JAVA 6.2
- Iacob Florin Matematica 7.88888889
- Lucanu Dorel OOP 7.88888889
- Masalagiu Cristian Logica 7.88888889
- Varlan Cosmin BD 7.8
- 8 ROWS selected.
- SQL> SELECT COUNT(*),profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof ORDER BY nume ASC;
- COUNT(*) NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- ---------- --------------- -----------------
- 5 Breaban Mihaela BD 7.8
- 5 Buraga Sabin Tehnologii Web 6.4
- 9 Ciobaca Stefan Logica 7.88888889
- 5 Frasinaru Cristian JAVA 6.2
- 9 Iacob Florin Matematica 7.88888889
- 9 Lucanu Dorel OOP 7.88888889
- 9 Masalagiu Cristian Logica 7.88888889
- 5 Varlan Cosmin BD 7.8
- 8 ROWS selected.
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof ORDER BY nume ASC;
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Breaban Mihaela BD 7.8
- Buraga Sabin Tehnologii Web 6.4
- Ciobaca Stefan Logica 7.88888889
- Frasinaru Cristian JAVA 6.2
- Iacob Florin Matematica 7.88888889
- Lucanu Dorel OOP 7.88888889
- Masalagiu Cristian Logica 7.88888889
- Varlan Cosmin BD 7.8
- 8 ROWS selected.
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof ORDER BY nume ASC;
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Breaban Mihaela BD 7.8
- Buraga Sabin Tehnologii Web 6.4
- Ciobaca Stefan Logica 7.88888889
- Frasinaru Cristian JAVA 6.2
- Iacob Florin Matematica 7.88888889
- Lucanu Dorel OOP 7.88888889
- Masalagiu Cristian Logica 7.88888889
- Varlan Cosmin BD 7.8
- 8 ROWS selected.
- SQL> SELECT AVG(valoare) FROM note GROUP BY valoare;
- AVG(VALOARE)
- ------------
- 6
- 5
- 4
- 8
- 7
- 9
- 10
- 7 ROWS selected.
- SQL> SELECT COUNT(*), AVG(valoare) FROM note GROUP BY valoare;
- COUNT(*) AVG(VALOARE)
- ---------- ------------
- 4 6
- 2 5
- 5 4
- 4 8
- 11 7
- 8 9
- 8 10
- 7 ROWS selected.
- SQL> SELECT SUM(AVG(valoare))/COUNT(*) FROM note GROUP BY valoare;
- SUM(AVG(VALOARE))/COUNT(*)
- --------------------------
- 7
- SQL> SELECT SUM(AVG(valoare)), COUNT(*) FROM note GROUP BY valoare;
- SUM(AVG(VALOARE)) COUNT(*)
- ----------------- ----------
- 49 7
- SQL> SELECT AVG(AVG(valoare))) FROM note GROUP BY valoare;
- SELECT AVG(AVG(valoare))) FROM note GROUP BY valoare
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare;
- AVG(AVG(VALOARE))
- -----------------
- 7
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) ORDER BY nume ASC;
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Breaban Mihaela BD 7.8
- Ciobaca Stefan Logica 7.88888889
- Iacob Florin Matematica 7.88888889
- Lucanu Dorel OOP 7.88888889
- Masalagiu Cristian Logica 7.88888889
- Varlan Cosmin BD 7.8
- 6 ROWS selected.
- SQL> SELECT profesori.nume, profesori.prenume, cursuri.titlu_curs, AVG(note.valoare) FROM profesori JOIN didactic ON didactic.id_prof = profesori.id_prof JOIN cursuri ON cursuri.id_curs = didactic.id_curs JOIN note ON cursuri.id_curs = note.id_curs GROUP BY cursuri.titlu_curs, profesori.nume, profesori.prenume, profesori.id_prof HAVING AVG(note.valoare) < (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) ORDER BY nume ASC;
- NUME PRENUME TITLU_CURS AVG(NOTE.VALOARE)
- ---------- ---------- --------------- -----------------
- Buraga Sabin Tehnologii Web 6.4
- Frasinaru Cristian JAVA 6.2
- SQL>
- SQL> SELECT profesori.nume, profesori.prenume, AVG(note.valoare)
- 2
- SQL>
- SQL>
- SQL> SELECT TRANSLATE(studenti.nume,'aeiou','AEIOU')||''||TRANSLATE(studenti.prenume,'aeiou','AEIOU')"YES" FROM studenti;
- YES
- --------------------------------------------------------------------------------
- POpEscUBOgdAn
- PrElIpcEAnRAdU
- AntOnIEIOAnA
- ArhIrERAlUcA
- PAnAItEAlExAndrU
- BOdnArIOAnA
- ArchIpAndrAdA
- CIObOtArIUCIprIAn
- BOdnArIOAnA
- PIntEscUAndrEI
- ArhIrEAlExAndrA
- YES
- --------------------------------------------------------------------------------
- CObzArUGEOrgE
- BUcUrAndrEEA
- 13 ROWS selected.
- SQL> SELECT TRANSLATE(LOWER(studenti.nume),'aeiou','AEIOU')||''||TRANSLATE(LOWER(studenti.prenume),'aeiou','AEIOU')"YES" FROM studenti;
- YES
- --------------------------------------------------------------------------------
- pOpEscUbOgdAn
- prElIpcEAnrAdU
- AntOnIEIOAnA
- ArhIrErAlUcA
- pAnAItEAlExAndrU
- bOdnArIOAnA
- ArchIpAndrAdA
- cIObOtArIUcIprIAn
- bOdnArIOAnA
- pIntEscUAndrEI
- ArhIrEAlExAndrA
- YES
- --------------------------------------------------------------------------------
- cObzArUgEOrgE
- bUcUrAndrEEA
- 13 ROWS selected.
- SQL> SELECT MIN(bursa) FROM studenti GROUP BY bursa;
- MIN(BURSA)
- ----------
- 450
- 250
- 350
- SQL> SELECT MIN(bursa) FROM studenti GROUP BY nr_matricol;
- MIN(BURSA)
- ----------
- 350
- 350
- 350
- 450
- 250
- MIN(BURSA)
- ----------
- 13 ROWS selected.
- SQL> SELECT MIN(bursa) FROM studenti GROUP BY nr_matricol HAVING bursa IS NOT NULL;
- SELECT MIN(bursa) FROM studenti GROUP BY nr_matricol HAVING bursa IS NOT NULL
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT MIN(bursa) FROM studenti GROUP BY nr_matricol, bursa HAVING bursa IS NOT NULL;
- MIN(BURSA)
- ----------
- 350
- 450
- 250
- 350
- 350
- SQL> SELECT MIN(bursa) FROM studenti GROUP BY nr_matricol, bursa HAVING bursa IS NOT NULL;
- MIN(BURSA)
- ----------
- 350
- 450
- 250
- 350
- 350
- SQL> SELECT MIN(bursa) FROM studenti GROUP BY bursa HAVING bursa IS NOT NULL;
- MIN(BURSA)
- ----------
- 450
- 250
- 350
- SQL> SELECT bursa FROM studenti GROUP BY bursa HAVING bursa IS NOT NULL;
- BURSA
- ----------
- 450
- 250
- 350
- SQL> SELECT bursa FROM studenti GROUP BY bursa HAVING bursa IS NOT NULL ORDER BY bursa ASC;
- BURSA
- ----------
- 250
- 350
- 450
- SQL>
- SQL> SELECT studenti.nr_matricol, studenti.nume, studenti.prenume FROM studenti WHERE bursa IS NOT NULL AND (bursa = (SELECT * FROM (SELECT bursa FROM studenti GROUP BY bursa HAVING bursa IS NOT NULL ORDER BY bursa ASC) WHERE ROWNUM=1) OR bursa = (SELECT * FROM (SELECT bursa FROM studenti GROUP BY bursa HAVING bursa IS NOT NULL ORDER BY bursa DESC) WHERE ROWNUM=1));
- NR_M NUME PRENUME
- ---- ---------- ----------
- 113 Antonie Ioana
- 120 Pintescu Andrei
- SQL> SELECT * FROM studenti ORDER BY bursa ASC WHERE bursa IS NOT NULL;
- SELECT * FROM studenti ORDER BY bursa ASC WHERE bursa IS NOT NULL
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL> SELECT * FROM studenti WHERE bursa IS NOT NULL;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 122 Cobzaru George 1 B1 350 29-APR-97
- SQL> SELECT * FROM note
- 2
- SQL> SELECT * FROM note;
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 111 21 8 17-FEB-14
- 111 22 9 19-FEB-14
- 111 23 10 24-JUN-14
- 111 24 9 17-FEB-15
- 111 25 7 20-JUN-15
- 111 26 8 21-JUN-15
- 112 21 7 25-FEB-14
- 112 22 6 19-FEB-14
- 112 23 5 24-JUN-14
- 112 24 6 17-FEB-15
- 112 25 7 20-JUN-15
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 112 26 4 21-JUN-15
- 113 21 9 17-FEB-14
- 113 22 9 19-FEB-14
- 113 23 7 24-JUN-14
- 113 24 10 17-FEB-15
- 113 25 4 20-JUN-15
- 113 26 7 21-JUN-15
- 114 21 6 17-FEB-14
- 114 22 9 19-FEB-14
- 114 23 10 24-JUN-14
- 114 24 4 17-FEB-15
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 114 25 5 20-JUN-15
- 114 26 4 21-JUN-15
- 115 21 10 17-FEB-14
- 115 22 7 19-FEB-14
- 115 23 10 24-JUN-14
- 115 24 10 17-FEB-15
- 115 25 8 20-JUN-15
- 115 26 9 21-JUN-15
- 116 21 10 18-FEB-15
- 116 22 10 20-FEB-15
- 116 23 9 21-JUN-15
- NR_M ID VALOARE DATA_NOTA
- ---- -- ---------- ---------
- 117 21 7 18-FEB-15
- 117 22 6 20-FEB-15
- 117 23 4 25-JUN-15
- 118 21 7 22-FEB-15
- 118 22 7 24-FEB-15
- 118 23 7 21-JUN-15
- 119 21 7 18-FEB-15
- 119 22 8 20-FEB-15
- 119 23 9 21-JUN-15
- 42 ROWS selected.
- SQL> SELECT * FROM cursuri;
- ID TITLU_CURS AN SEMESTRU CREDITE
- -- --------------- ---------- ---------- ----------
- 21 Logica 1 1 5
- 22 Matematica 1 1 4
- 23 OOP 1 2 5
- 24 BD 2 1 8
- 25 JAVA 2 2 5
- 26 Tehnologii Web 2 2 5
- 27 Sec. Info. 3 1 5
- 28 DSFUM 3 1 6
- 29 Limbaje formale 2 1 5
- 9 ROWS selected.
- SQL>
- SQL> SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume;
- SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, cursuri.credite;
- NUME Credite
- ---------- ----------
- Bodnar 40
- Ciobotariu 70
- Panaite 185
- Archip 55
- Prelipcean 24
- Panaite 28
- Ciobotariu 28
- Bodnar 32
- Popescu 165
- Antonie 80
- Arhire 125
- NUME Credite
- ---------- ----------
- Arhire 36
- Archip 24
- Popescu 36
- Prelipcean 115
- Antonie 135
- Antonie 36
- Arhire 32
- Bodnar 95
- Prelipcean 48
- Popescu 72
- Panaite 80
- NUME Credite
- ---------- ----------
- Bodnar 80
- 23 ROWS selected.
- SQL> SELECT AVG(valoare) FROM note GROUP BY valoare
- 2
- SQL>
- SQL> SELECT AVG(valoare) FROM note GROUP BY valoarel
- 2
- SQL> SELECT AVG(valoare) FROM note GROUP BY valoare;
- AVG(VALOARE)
- ------------
- 6
- 5
- 4
- 8
- 7
- 9
- 10
- 7 ROWS selected.
- SQL> SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare;
- AVG(AVG(VALOARE))
- -----------------
- 7
- SQL>
- SQL> SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, cursuri.credite
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- *
- ERROR AT line 2:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, cursuri.credite, studenti.prenume
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- NUME Credite
- ---------- ----------
- Antonie 36
- Antonie 80
- Arhire 36
- Bodnar 40
- Bodnar 95
- Bodnar 32
- Bodnar 80
- 7 ROWS selected.
- SQL> ORDER BY studenti.nume ASC;SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, cursuri.credite
- SP2-0734: unknown command beginning "ORDER BY s..." - rest OF line ignored.
- SQL> HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- SP2-0734: unknown command beginning "HAVING avg..." - rest OF line ignored.
- SQL> ORDER BY studenti.nume ASC;
- SP2-0734: unknown command beginning "ORDER BY s..." - rest OF line ignored.
- SQL>
- SQL> SELECT studenti.nume, SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, cursuri.credite
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- NUME Credite
- ---------- ----------
- Antonie 36
- Antonie 80
- Arhire 36
- Bodnar 40
- Bodnar 95
- Bodnar 32
- Bodnar 80
- 7 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume,SUM(note.valoare)*cursuri.credite"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, cursuri.credite
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- NUME PRENUME Credite
- ---------- ---------- ----------
- Antonie Ioana 36
- Antonie Ioana 80
- Arhire Raluca 36
- Bodnar Ioana 40
- Bodnar Ioana 95
- Bodnar Ioana 32
- Bodnar Ioana 80
- 7 ROWS selected.
- SQL> SELECT studenti.nume, studenti.prenume,SUM(note.valoare)*SUM(cursuri.credite)"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- NUME PRENUME Credite
- ---------- ---------- ----------
- Antonie Ioana 1472
- Bodnar Ioana 406
- Bodnar Ioana 336
- SQL> ORDER BY studenti.nume ASC;
- SP2-0734: unknown command beginning "ORDER BY s..." - rest OF line ignored.
- SQL>
- SQL>
- SQL>
- SQL> SELECT studenti.nr_matricol,studenti.nume, studenti.prenume,SUM(note.valoare)*SUM(cursuri.credite)"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- NR_M NUME PRENUME Credite
- ---- ---------- ---------- ----------
- 113 Antonie Ioana 1472
- 116 Bodnar Ioana 406
- 119 Bodnar Ioana 336
- SQL>
- SQL>
- SQL> SELECT studenti.nr_matricol,studenti.nume, studenti.prenume,AVG(note.valoare),SUM(note.valoare)*SUM(cursuri.credite)"Credite" FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol JOIN cursuri ON cursuri.id_curs = note.id_curs GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume
- 2 HAVING AVG(note.valoare) > (SELECT AVG(AVG(valoare)) FROM note GROUP BY valoare) AND SUBSTR(studenti.prenume,-1) LIKE '%a'
- 3 ORDER BY studenti.nume ASC;
- NR_M NUME PRENUME AVG(NOTE.VALOARE) Credite
- ---- ---------- ---------- ----------------- ----------
- 113 Antonie Ioana 7.66666667 1472
- 116 Bodnar Ioana 9.66666667 406
- 119 Bodnar Ioana 8 336
- SQL> SELECT STDDEV(valoare) FROM note GROUP BY valoare;
- STDDEV(VALOARE)
- ---------------
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 7 ROWS selected.
- SQL> SELECT STDDEV(STDDEV(valoare)) FROM note GROUP BY valoare;
- STDDEV(STDDEV(VALOARE))
- -----------------------
- 0
- SQL> SELECT STDDEV(STDDEV(valoare)) FROM note;
- SELECT STDDEV(STDDEV(valoare)) FROM note
- *
- ERROR AT line 1:
- ORA-00978: nested GROUP FUNCTION without GROUP BY
- SQL> SELECT STDDEV(valoare) FROM note;
- STDDEV(VALOARE)
- ---------------
- 1.94120908
- SQL> SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note);
- SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note)
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note);
- SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume HAVING studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note)
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa HAVING studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note);
- NUME PRENUME STDDEV(NOTE.VALOARE)
- ---------- ---------- --------------------
- Bodnar Ioana 1
- Panaite Alexandru 1.26491106
- Popescu Bogdan 1.04880885
- Prelipcean Radu 1.16904519
- Bodnar Ioana .577350269
- SQL>
- SQL> SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note);
- SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol WHERE studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note)
- *
- ERROR AT line 1:
- ORA-00934: GROUP FUNCTION IS NOT allowed here
- SQL> SELECT STDDEV(valoare) FROM note;
- STDDEV(VALOARE)
- ---------------
- 1.94120908
- SQL> SELECT studenti.nume, studenti.prenume, STDDEV(note.valoare) FROM studenti JOIN note ON note.nr_matricol = studenti.nr_matricol GROUP BY studenti.nr_matricol, studenti.nume, studenti.prenume, studenti.bursa HAVING studenti.bursa IS NULL AND STDDEV(note.valoare) < (SELECT STDDEV(valoare) FROM note);
- NUME PRENUME STDDEV(NOTE.VALOARE)
- ---------- ---------- --------------------
- Bodnar Ioana 1
- Panaite Alexandru 1.26491106
- Popescu Bogdan 1.04880885
- Prelipcean Radu 1.16904519
- Bodnar Ioana .577350269
- SQL> SELECT * FROM studenti ORDER BY nume DESC, prenume DESC, grupa;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 115 Panaite Alexandru 3 B3 13-APR-95
- 122 Cobzaru George 1 B1 350 29-APR-97
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 123 Bucur Andreea 1 B2 10-MAY-97
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 114 Arhire Raluca 3 A4 26-DEC-95
- 121 Arhire Alexandra 1 B1 02-JUL-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 117 Archip Andrada 2 A1 350 03-APR-96
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 13 ROWS selected.
- SQL> SELECT * FROM studenti ORDER BY nume, prenume DESC, grupa;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 114 Arhire Raluca 3 A4 26-DEC-95
- 121 Arhire Alexandra 1 B1 02-JUL-97
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 123 Bucur Andreea 1 B2 10-MAY-97
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 122 Cobzaru George 1 B1 350 29-APR-97
- 115 Panaite Alexandru 3 B3 13-APR-95
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 13 ROWS selected.
- SQL> SELECT * FROM studenti ORDER BY nume, prenume DESC, grupa;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 114 Arhire Raluca 3 A4 26-DEC-95
- 121 Arhire Alexandra 1 B1 02-JUL-97
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 123 Bucur Andreea 1 B2 10-MAY-97
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 122 Cobzaru George 1 B1 350 29-APR-97
- 115 Panaite Alexandru 3 B3 13-APR-95
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 13 ROWS selected.
- SQL> SELECT * FROM studenti ORDER BY nume, prenume DESC, grupa;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 114 Arhire Raluca 3 A4 26-DEC-95
- 121 Arhire Alexandra 1 B1 02-JUL-97
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 123 Bucur Andreea 1 B2 10-MAY-97
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 122 Cobzaru George 1 B1 350 29-APR-97
- 115 Panaite Alexandru 3 B3 13-APR-95
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 13 ROWS selected.
- SQL>
- SQL>
- SQL> SELECT nume, prenume, grupa FROM (SELECT *,ROWNUM FROM studenti ORDER BY nume, prenume DESC, grupa)
- 2 .
- SQL> SELECT nume, prenume, grupa FROM (SELECT *,ROWNUM FROM studenti ORDER BY nume, prenume DESC, grupa);
- SELECT nume, prenume, grupa FROM (SELECT *,ROWNUM FROM studenti ORDER BY nume, prenume DESC, grupa)
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT nume, prenume, grupa FROM (SELECT *,ROWNUM FROM studenti ORDER BY nume, prenume DESC, grupa);
- SELECT nume, prenume, grupa FROM (SELECT *,ROWNUM FROM studenti ORDER BY nume, prenume DESC, grupa)
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT nume, prenume, grupa FROM (SELECT *, ROWNUM"R" FROM studenti ORDER BY nume, prenume DESC, grupa);
- SELECT nume, prenume, grupa FROM (SELECT *, ROWNUM"R" FROM studenti ORDER BY nume, prenume DESC, grupa)
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT nume, prenume, grupa FROM (SELECT * FROM studenti ORDER BY nume, prenume DESC, grupa);
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Raluca A4
- Arhire Alexandra B1
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- Ciobotariu Ciprian A1
- Cobzaru George B1
- Panaite Alexandru B3
- Pintescu Andrei B1
- NUME PRENUME GR
- ---------- ---------- --
- Popescu Bogdan A2
- Prelipcean Radu A2
- 13 ROWS selected.
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row",* FROM studenti)
- 2 ;
- SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row",* FROM studenti)
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS ROW,* FROM studenti)
- 2 ;
- SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS ROW,* FROM studenti)
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS ROW, nume, prenume, grupa FROM studenti)
- 2 ;
- SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS ROW, nume, prenume, grupa FROM studenti)
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS , nume, prenume, grupa FROM studenti);
- NUME PRENUME GR
- ---------- ---------- --
- Popescu Bogdan A2
- Prelipcean Radu A2
- Antonie Ioana A2
- Arhire Raluca A4
- Panaite Alexandru B3
- Bodnar Ioana A1
- Archip Andrada A1
- Ciobotariu Ciprian A1
- Bodnar Ioana B2
- Pintescu Andrei B1
- Arhire Alexandra B1
- NUME PRENUME GR
- ---------- ---------- --
- Cobzaru George B1
- Bucur Andreea B2
- 13 ROWS selected.
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti);
- NUME PRENUME GR
- ---------- ---------- --
- Popescu Bogdan A2
- Prelipcean Radu A2
- Antonie Ioana A2
- Arhire Raluca A4
- Panaite Alexandru B3
- Bodnar Ioana A1
- Archip Andrada A1
- Ciobotariu Ciprian A1
- Bodnar Ioana B2
- Pintescu Andrei B1
- Arhire Alexandra B1
- NUME PRENUME GR
- ---------- ---------- --
- Cobzaru George B1
- Bucur Andreea B2
- 13 ROWS selected.
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti) WHERE ROW=3,5,7;
- SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti) WHERE ROW=3,5,7
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti) WHERE "Row"=3,5,7;
- SELECT nume, prenume, grupa FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti) WHERE "Row"=3,5,7
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL> SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti WHERE "Row"=3,5,7);
- SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY nume, prenume DESC, grupa) AS "Row", nume, prenume, grupa FROM studenti WHERE "Row"=3,5,7)
- *
- ERROR AT line 1:
- ORA-00907: missing right parenthesis
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUMM<8;
- SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUMM<8
- *
- ERROR AT line 1:
- ORA-00904: "ROWNUMM": invalid identifier
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Raluca A4
- Arhire Alexandra B1
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 7 ROWS selected.
- SQL> SELECT ROWNUM,* FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- SELECT ROWNUM,* FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT ROWNUM * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- SELECT ROWNUM * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT ROWNUM AND * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- SELECT ROWNUM AND * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT ROWNUM||* FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- SELECT ROWNUM||* FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Raluca A4
- Arhire Alexandra B1
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 7 ROWS selected.
- SQL> SELECT * FROM (SELECT nume, prenume, grupa, ROWNUM FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8;
- NUME PRENUME GR ROWNUM
- ---------- ---------- -- ----------
- Antonie Ioana A2 3
- Archip Andrada A1 7
- Arhire Raluca A4 4
- Arhire Alexandra B1 11
- Bodnar Ioana A1 6
- Bodnar Ioana B2 9
- Bucur Andreea B2 13
- 7 ROWS selected.
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<8
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1
- 4 MINUS
- 5 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=2
- 6 MINUS
- 7 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=4
- 8 MINUS
- 9 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=6;
- NUME PRENUME GR
- ---------- ---------- --
- Archip Andrada A1
- Arhire Alexandra B1
- Arhire Raluca A4
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 6 ROWS selected.
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=7
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1
- 4 MINUS
- 5 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=2
- 6 MINUS
- 7 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=4
- 8 MINUS
- 9 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=6
- 10 ;
- NUME PRENUME GR
- ---------- ---------- --
- Archip Andrada A1
- Arhire Alexandra B1
- Arhire Raluca A4
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 6 ROWS selected.
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=3;
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Raluca A4
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=3
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1;
- NUME PRENUME GR
- ---------- ---------- --
- Archip Andrada A1
- Arhire Raluca A4
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=3
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1,2,4,
- 4
- SQL>
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=7
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1,2,4,6;
- SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1,2,4,6
- *
- ERROR AT line 3:
- ORA-00933: SQL command NOT properly ended
- SQL>
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=7
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM=1 AND ROWNUM=2 AND ROWNUM=4 AND ROWNUM=6;
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Alexandra B1
- Arhire Raluca A4
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 7 ROWS selected.
- SQL>
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=7
- 2 MINUS
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE (ROWNUM=1 AND ROWNUM=2 AND ROWNUM=4 AND ROWNUM=6);
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Alexandra B1
- Arhire Raluca A4
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 7 ROWS selected.
- SQL>
- SQL> SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE ROWNUM<=7
- 2 MINUS(
- 3 SELECT * FROM (SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa) WHERE (ROWNUM=1 AND ROWNUM=2 AND ROWNUM=4 AND ROWNUM=6));
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Alexandra B1
- Arhire Raluca A4
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- 7 ROWS selected.
- SQL> SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa;
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Raluca A4
- Arhire Alexandra B1
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- Ciobotariu Ciprian A1
- Cobzaru George B1
- Panaite Alexandru B3
- Pintescu Andrei B1
- NUME PRENUME GR
- ---------- ---------- --
- Popescu Bogdan A2
- Prelipcean Radu A2
- 13 ROWS selected.
- SQL> SELECT nume, prenume, grupa FROM studenti ORDER BY nume, prenume DESC, grupa;
- NUME PRENUME GR
- ---------- ---------- --
- Antonie Ioana A2
- Archip Andrada A1
- Arhire Raluca A4
- Arhire Alexandra B1
- Bodnar Ioana A1
- Bodnar Ioana B2
- Bucur Andreea B2
- Ciobotariu Ciprian A1
- Cobzaru George B1
- Panaite Alexandru B3
- Pintescu Andrei B1
- NUME PRENUME GR
- ---------- ---------- --
- Popescu Bogdan A2
- Prelipcean Radu A2
- 13 ROWS selected.
- SQL>
- SQL>
- SQL> SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';
- SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a'
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE
- 2
- SQL> SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';
- NUME PRENUME
- ---------- ----------
- Archip Andrada
- Antonie Ioana
- SQL> SELECT * FROM studenti;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 114 Arhire Raluca 3 A4 26-DEC-95
- 115 Panaite Alexandru 3 B3 13-APR-95
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 121 Arhire Alexandra 1 B1 02-JUL-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 122 Cobzaru George 1 B1 350 29-APR-97
- 123 Bucur Andreea 1 B2 10-MAY-97
- 13 ROWS selected.
- SQL> SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';
- SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a'
- *
- ERROR AT line 1:
- ORA-00911: invalid character
- SQL>
- SQL> SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';
- NUME PRENUME
- ---------- ----------
- Antonie Ioana
- Archip Andrada
- SQL> SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';
- SELECT nume, prenume FROM studenti GROUP BY an, grupa, nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a';SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a'
- *
- ERROR AT line 1:
- ORA-00911: invalid character
- SQL>
- SQL>
- SQL> SELECT an, COUNT(*) FROM studenti GROUP BY an;
- AN COUNT(*)
- ---------- ----------
- 1 4
- 2 4
- 3 5
- SQL> SELECT an FROM studenti GROUP BY an HAVING MAX(COUNT(*));
- SELECT an FROM studenti GROUP BY an HAVING MAX(COUNT(*))
- *
- ERROR AT line 1:
- ORA-00935: GROUP FUNCTION IS nested too deeply
- SQL> SELECT an, MAX(COUNT(*)) FROM studenti GROUP BY an;
- SELECT an, MAX(COUNT(*)) FROM studenti GROUP BY an
- *
- ERROR AT line 1:
- ORA-00937: NOT a single-GROUP GROUP FUNCTION
- SQL> SELECT an, MAX(COUNT(ALL)) FROM studenti GROUP BY an;
- SELECT an, MAX(COUNT(ALL)) FROM studenti GROUP BY an
- *
- ERROR AT line 1:
- ORA-00909: invalid NUMBER OF arguments
- SQL> SELECT an, MAX(COUNT(DISTINCT)) FROM studenti GROUP BY an;
- SELECT an, MAX(COUNT(DISTINCT)) FROM studenti GROUP BY an
- *
- ERROR AT line 1:
- ORA-00909: invalid NUMBER OF arguments
- SQL> SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC WHERE ROWNUM=1;
- SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC WHERE ROWNUM=1
- *
- ERROR AT line 1:
- ORA-00933: SQL command NOT properly ended
- SQL> SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC WHERE ROWNUM=1) WHERE ROWNUM=1;
- SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC WHERE ROWNUM=1) WHERE ROWNUM=1
- *
- ERROR AT line 1:
- ORA-00907: missing right parenthesis
- SQL> SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM=1;
- AN
- ----------
- 3
- SQL> SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a' AND an = (SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a' AND an = (SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM=1)
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT nume, prenume FROM studenti GROUP BY nr_matricol, nume, prenume, bursa, an HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a' AND an = (SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- NUME PRENUME
- ---------- ----------
- Antonie Ioana
- SQL> SELECT * FROM studenti GROUP BY nr_matricol, nume, prenume, bursa, an HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a' AND an = (SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY nr_matricol, nume, prenume, bursa, an HAVING bursa IS NOT NULL AND SUBSTR(prenume,-1) LIKE '%a' AND an = (SELECT * FROM (SELECT an FROM studenti GROUP BY an ORDER BY COUNT(*) DESC) WHERE ROWNUM=1)
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT grupa, COUNT(*) FROM studenti GROUP BY an, grupa;
- GR COUNT(*)
- -- ----------
- A2 3
- A4 1
- B3 1
- B2 1
- A1 3
- B2 1
- B1 3
- 7 ROWS selected.
- SQL> SELECT grupa, COUNT(*) FROM studenti GROUP BY grupa;
- GR COUNT(*)
- -- ----------
- A2 3
- A1 3
- B1 3
- A4 1
- B3 1
- B2 2
- 6 ROWS selected.
- SQL> SELECT grupa, COUNT(*) FROM studenti GROUP BY an, grupa;
- GR COUNT(*)
- -- ----------
- A2 3
- A4 1
- B3 1
- B2 1
- A1 3
- B2 1
- B1 3
- 7 ROWS selected.
- SQL>
- SQL> SELECT grupa, COUNT(*) FROM studenti GROUP BY an, grupa HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY grupa ORDER BY COUNT(*)) WHERE ROWNUM=1);
- GR COUNT(*)
- -- ----------
- A4 1
- B3 1
- B2 1
- B2 1
- SQL> SELECT grupa, COUNT(*) FROM studenti GROUP BY an, grupa HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*)) WHERE ROWNUM=1);
- GR COUNT(*)
- -- ----------
- A4 1
- B3 1
- B2 1
- B2 1
- SQL> SELECT grupa, COUNT(*) FROM studenti GROUP BY an, grupa HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- GR COUNT(*)
- -- ----------
- A2 3
- A1 3
- B1 3
- SQL> SELECT * FROM studenti GROUP BY an, grupa HAVING COUNT(*) =
- 2 (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY an, grupa HAVING COUNT(*) =
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT * FROM studenti GROUP BY an, grupa HAVING COUNT(*) =
- 2 (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY an, grupa HAVING COUNT(*) =
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL>
- SQL> SELECT * FROM studenti GROUP BY an, grupa HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY an, grupa HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1)
- *
- ERROR AT line 1:
- ORA-00979: NOT a GROUP BY expression
- SQL> SELECT * FROM studenti GROUP BY * HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY * HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1)
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL>
- SQL> SELECT * FROM studenti GROUP BY * HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY * HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1)
- *
- ERROR AT line 1:
- ORA-00936: missing expression
- SQL>
- SQL> SELECT * FROM studenti;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 114 Arhire Raluca 3 A4 26-DEC-95
- 115 Panaite Alexandru 3 B3 13-APR-95
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 121 Arhire Alexandra 1 B1 02-JUL-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 122 Cobzaru George 1 B1 350 29-APR-97
- 123 Bucur Andreea 1 B2 10-MAY-97
- 13 ROWS selected.
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nasterii HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nasterii HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1)
- *
- ERROR AT line 1:
- ORA-00904: "DATA_NASTERII": invalid identifier
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere HAVING COUNT(*) = (SELECT * FROM (SELECT COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- no ROWS selected
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere HAVING grupa = ALL(SELECT * FROM (SELECT grupa FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1);
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 122 Cobzaru George 1 B1 350 29-APR-97
- 121 Arhire Alexandra 1 B1 02-JUL-97
- SQL> SELECT grupa FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC;
- GR
- --
- A2
- A1
- B1
- B2
- B3
- A4
- B2
- 7 ROWS selected.
- SQL> SELECT grupa,COUNT(*) FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC;
- GR COUNT(*)
- -- ----------
- A2 3
- A1 3
- B1 3
- B2 1
- B3 1
- A4 1
- B2 1
- 7 ROWS selected.
- SQL> SELECT * FROM (SELECT grupa FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM=1;
- GR
- --
- A2
- SQL> SELECT * FROM (SELECT grupa FROM studenti GROUP BY an, grupa ORDER BY COUNT(*) DESC) WHERE ROWNUM<4;
- GR
- --
- A2
- B1
- A1
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 115 Panaite Alexandru 3 B3 13-APR-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 122 Cobzaru George 1 B1 350 29-APR-97
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 121 Arhire Alexandra 1 B1 02-JUL-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 114 Arhire Raluca 3 A4 26-DEC-95
- 123 Bucur Andreea 1 B2 10-MAY-97
- 13 ROWS selected.
- SQL> SELECT COUNT(grupa) FROM studenti GROUP BY grupa;
- COUNT(GRUPA)
- ------------
- 3
- 3
- 3
- 1
- 1
- 2
- 6 ROWS selected.
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere ORDER BY grupa;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 117 Archip Andrada 2 A1 350 03-APR-96
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 114 Arhire Raluca 3 A4 26-DEC-95
- 121 Arhire Alexandra 1 B1 02-JUL-97
- 122 Cobzaru George 1 B1 350 29-APR-97
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 119 Bodnar Ioana 2 B2 10-JUN-96
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 123 Bucur Andreea 1 B2 10-MAY-97
- 115 Panaite Alexandru 3 B3 13-APR-95
- 13 ROWS selected.
- SQL> SELECT grupa, COUNT(grupa) FROM studenti GROUP BY grupa ORDER BY GRUPA;
- GR COUNT(GRUPA)
- -- ------------
- A1 3
- A2 3
- A4 1
- B1 3
- B2 2
- B3 1
- 6 ROWS selected.
- SQL> SELECT grupa, COUNT(grupa), MAX(COUNT(grupa)) FROM studenti GROUP BY grupa ORDER BY GRUPA;
- SELECT grupa, COUNT(grupa), MAX(COUNT(grupa)) FROM studenti GROUP BY grupa ORDER BY GRUPA
- *
- ERROR AT line 1:
- ORA-00937: NOT a single-GROUP GROUP FUNCTION
- SQL> SELECT grupa, COUNT(grupa) FROM studenti GROUP BY grupa ORDER BY GRUPA;
- GR COUNT(GRUPA)
- -- ------------
- A1 3
- A2 3
- A4 1
- B1 3
- B2 2
- B3 1
- 6 ROWS selected.
- SQL> SELECT COUNT(grupa) FROM studenti GROUP BY grupa ORDER BY GRUPA;
- COUNT(GRUPA)
- ------------
- 3
- 3
- 1
- 3
- 2
- 1
- 6 ROWS selected.
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere HAVING COUNT(grupa) = 3;
- no ROWS selected
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 115 Panaite Alexandru 3 B3 13-APR-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 122 Cobzaru George 1 B1 350 29-APR-97
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 121 Arhire Alexandra 1 B1 02-JUL-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 114 Arhire Raluca 3 A4 26-DEC-95
- 123 Bucur Andreea 1 B2 10-MAY-97
- 13 ROWS selected.
- SQL> SELECT *,COUNT(*) FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere;
- SELECT *,COUNT(*) FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere
- *
- ERROR AT line 1:
- ORA-00923: FROM keyword NOT found WHERE expected
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere;
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 115 Panaite Alexandru 3 B3 13-APR-95
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 122 Cobzaru George 1 B1 350 29-APR-97
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 119 Bodnar Ioana 2 B2 10-JUN-96
- 121 Arhire Alexandra 1 B1 02-JUL-97
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 114 Arhire Raluca 3 A4 26-DEC-95
- 123 Bucur Andreea 1 B2 10-MAY-97
- 13 ROWS selected.
- SQL>
- SQL>
- SQL>
- SQL> SELECT * FROM studenti GROUP BY nr_matricol,nume,prenume,an,grupa,bursa,data_nastere HAVING grupa IN (SELECT grupa FROM studenti GROUP BY an, grupa HAVING COUNT(grupa)=3);
- NR_M NUME PRENUME AN GR BURSA DATA_NAST
- ---- ---------- ---------- ---------- -- ---------- ---------
- 116 Bodnar Ioana 2 A1 26-AUG-96
- 117 Archip Andrada 2 A1 350 03-APR-96
- 118 Ciobotariu Ciprian 2 A1 350 03-APR-96
- 120 Pintescu Andrei 1 B1 250 26-AUG-97
- 111 Popescu Bogdan 3 A2 17-FEB-95
- 112 Prelipcean Radu 3 A2 26-MAY-95
- 122 Cobzaru George 1 B1 350 29-APR-97
- 113 Antonie Ioana 3 A2 450 03-JAN-95
- 121 Arhire Alexandra 1 B1 02-JUL-97
- 9 ROWS selected.
- SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement