Hi all,
Heres the scenario i want to make a query of
I have four Tables namely: Bug, Test, REQ and REQ_COVER
Bug Schema:
BUG_ID
TEST_REFERENCE
BUG_DESC
BUG_RESPONSIBLE

TEST Schema:
TEST_ID(Relation with BUG.TEST_REFERENCE
TEST_NAME

REQ Schema:
REQ_ID
REQ_NAME

REQ_COVER Schema:
RC_REQ_ID (Relation with REQ.REQ_ID)
RC_TEST_ID (Relation with TEST.TEST_ID)

Now I need to have following data:
Number of BUG_ID by BG_RESPONSIBLE with Number of Distinct TEST_ID and Number of Distinct REQ_ID.
i.e. how many BUG_ID (number of bugs )are assigned to BG_RESPONSIBLE (list of users) and that BUG_ID is assoiciated with how many TEST_ID(TestCases) and those TEST_IDs are associated to how many REQ_ID(Requirements).

Any assistance will be highly appriciated

please give sample output from the query

BG_RESPONSIBLE || Count(BUG_ID against BG_RESPONSIBLE) || Count(TEST_ID against BUG_ID for BG_RESPONSIBLE) || Count(REQ_ID against TEST_ID against BUG_ID for BG_RESPONSIBLE)

Ineed the records in above table Columns are separated by || signs.
Actually this is custom Bug tracker. And i need to know the total number of Bugs , total number of test cases they belongs to and the total number of requirements associated with those test cases.. all against each developer (BG_RESPONSIBLE)