question 3

Hi again,
I have this 3 tables:
esame=> select * from prestito\g
id_libro|id_utente|data_prestito|visto|notifica1|notifica2|notifica3
--------+---------+-------------+-----+---------+---------+---------
11| 37| 12-04-1998|f | | |
(1 row)

esame=> select * from utente\g
cognome |nome |id_utente|indirizzo |
telefono|tipo_utente|info_utente |l
ibri_presi| notifica1| notifica2| notifica3|password|email
--------+--------+---------+----------------+------------+-----------+------------------+-
----------+----------+----------+----------+--------+--------------
Ballabio|Dario | 37|Via carducci 125| 02-2422700|
1|Ditta Enter S.r.L.|
| | | |dario |dario(at)pinco(dot)it

esame=> select * from libro\g
titolo |id_libro|id_utente|collocazione|casa_edit|
data_publ|tipo|difetto|id_libro_ke
y
------------+--------+---------+------------+---------+----------+----+-------+-----------
-
Il talismano|s1 | 0|d1 |aop2 |05-12-1985| 1|
| 1
2
It |d1 | 37|d1 |apo |05-12-1940| 1|
| 1
1

I need a query that for each id_utente return me the numeber of items in
"prestito" and th
is number is group by libro.tipo

"Il divertimento e' giusto se la scimmia ci prende gusto"
--
Italian Linux Press: http://ziobudda.enter.it/ILP/
--
Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group
michel(at)michel(dot)enter(dot)it - http://ziobudda.enter.it/
Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"