Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- biblio=> select k.leidykla, e.ISBN, COUNT(e.ISBN) from stud.egzempliorius AS e, stud.knyga as k WHERE e.ISBN = k.ISBN GROUP BY k.leidykla, e.ISBN;
- leidykla | isbn | count
- --------------+---------------+-------
- Juodoji | 9999-02-203-0 | 4
- Baltoji | 9998-01-103-5 | 6
- Baltoji | 9998-01-102-7 | 2
- Raudonoji | 9997-03-303-5 | 4
- Baltoji | 9998-01-104-3 | 4
- Baltoji | 9998-01-101-9 | 9
- Juodoji | 9999-02-202-2 | 3
- (7 rows)
- biblio=> select k.leidykla, COUNT(e.ISBN) from stud.egzempliorius AS e, stud.knyga as k WHERE e.ISBN = k.ISBN GROUP BY k.leidykla;
- leidykla | count
- --------------+-------
- Raudonoji | 4
- Juodoji | 7
- Baltoji | 21
- (3 rows)
Add Comment
Please, Sign In to add comment