Here is an example of how to extract the manual test with his steps you can instead of select the DESSTEPS count them.

SELECT
TEST.TS_TEST_ID as ''Test ID'', /*Test.Test ID*/
TEST.TS_SUBJECT, /*Test.Subject*/
TEST.TS_NAME as ''Test Name'', /*Test.Test Name*/
TEST.TS_DESCRIPTION as ''Test Desc.'', /*Test.Description*/
DESSTEPS.DS_STEP_NAME as ''Step Name'', /*Design Step.Step Name*/
DESSTEPS.DS_DESCRIPTION as ''Step Desc.'', /*Design Step.Description*/
DESSTEPS.DS_EXPECTED as ''Expected Result'', /*Design Step.Expected Result*/
TEST.TS_STATUS as ''Test Status'', /*Test.Status*/
TEST.TS_TYPE ''Test Type'', /*Test.Type*/
TEST.TS_RESPONSIBLE as ''Test Designer'', /*Test.Designer*/
TEST.TS_USER_03 as ''Test Priority'', /*Test.Priority*/
TEST.TS_USER_04 as ''Test Reviewer'' /*Test.Reviewer*/

FROM
Test,
DESSTEPS

WHERE
DS_TEST_ID = TS_TEST_ID

SELECT TEST.TS_TEST_ID as ''Test ID'', /*Test.Test ID*/
TEST.TS_NAME as ''Test Name'', /*Test.Test Name*/
TEST.TS_SUBJECT as ''Subject'',
TEST.TS_DESCRIPTION as ''Test Desc.'', /*Test.Description*/
TEST.TS_DEV_COMMENTS as ''Comments'',
TEST.TS_TYPE as ''Test Type'', /*Test.Type*/
COMPONENT_STEP.CS_STEP_NAME as ''Step Name'',
COMPONENT_STEP.CS_DESCRIPTION as ''Step Description'',
COMPONENT_STEP.CS_EXPECTED as ''Expected Results''

FROM ALL_LISTS
Left Join TEST on ALL_LISTS.AL_ITEM_ID=TEST.TS_SUBJECT
Left join BPTEST_TO_COMPONENTS on TEST.TS_TEST_ID=BPTEST_TO_COMPONENTS.BC_PARENT_ID
Left join COMPONENT_STEP on BPTEST_TO_COMPONENTS.BC_CO_ID=COMPONENT_STEP.CS_COMPONENT_ID

where
BC_PARENT_ID = TS_TEST_ID
AND AL_ITEM_ID = TS_SUBJECT
AND TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
ORDER BY TS_TEST_ID

By using the above query I am getting the BPT Component steps but i want to get the count of them.
Please help me out