Create View V1 as

Select ΚΩΔΒΙΒΛΙΟΥ, count(ΚΩΔΔΑΝ)as PLHTHOS1

From ΔΑΝΕΙΣΜΟΙ

Group by ΚΩΔΑΝΑΓ

 

 

Create View V2 as

Select ΚΩΔΒΙΒΛΙΟΥ, ΤΙΤΛΟΣ, count(ΚΩΔΔΑΝ)as PLHTHOS2

From ΔΑΝΕΙΣΜΟΙ

Order by ΚΩΔΒΙΒΛΙΟΥ desc