Help!!! on SqlPlus query

From: Hongbo Zhang <hongbozhang_at_yahoo.com>
Date: Fri, 09 Apr 1999 12:44:46 GMT
Message-ID: <2DmP2.899$0C1.109214@carnaval.risq.qc.ca>

Hi,

I am new on Oracle. I have 4 following tables:

HOSPITAL:

---

CODE_H | NAME_H |

---

MEDECIN:

---

CODE_M | NAME_M |

---

HOS_MED:

---

CODE_H | CODE_M |

---

MED_PAT_HOS:

---

CODE_M | CODE_H | CODE_PATENT |

---

Would you please help me to realize this query with Oracle Sqlplus: for every MEDECIN,
find the name of hospital he works and count the nomber of patients he treats.

Thanks

Hongbo Received on Fri Apr 09 1999 - 07:44:46 CDT