BD

SELECT s.nume, s.prenume, f.isbn FROM Studenti s, Fisa f WHERE s.cnp = f.cnp AND f.data_i + 30 < f.data_r
LIST

x = VAL(ACCEPT("Numarul de zile"))
DATA = DATE()
SELECT s.nume, s.prenume FROM Studenti s, Fisa f WHERE s.cnp = f.cnp AND :DATA+:x >= f.data_r
LIST

cnp = TRIM(ACCEPT("CNP"))

SELECT s.nume, s.prenume, c.titlu FROM Fisa f INNER JOIN Studenti s ON s.cnp = f.cnp INNER JOIN Carti c ON c.isbn = f.isbn WHERE f.cnp = :cnp
LIST

SELECT f.cnp, s.nume, s.prenume, COUNT(f.cnp) AS cnt FROM Fisa f INNER JOIN Studenti s ON s.cnp = f.cnp INNER JOIN Carti c ON c.isbn = f.isbn GROUP BY f.cnp, s.nume, s.prenume ORDER BY cnt DESC, f.cnp DESC
DISP

SELECT f.isbn, c.titlu, c.autor, COUNT(f.isbn) AS cnt FROM Fisa f INNER JOIN Carti c ON c.isbn = f.isbn GROUP BY f.isbn, c.titlu, c.autor ORDER BY cnt DESC, f.isbn DESC
DISP

CLOSE ALL