merge two queries into one

[kkshansid]

State wise count of excellent (max pass count centres)
query1->

Select  code,sum( IF(PASS_FAIL='P',1,0)) AS Cp from table group by code

I made table5 from above query then i executed query2 to get desired data
Query2->

SELECT Sheet1.state, code,Sheet1.address,stdcnt
FROM Table5 INNER JOIN Sheet1 ON Table5.code = Sheet1.centrecode
order by state,stdcnt  desc;

kindly help me to merge these two queries into one

[code green]

it would be helpful if you could be bothered to:
1. Use code tags
2. Used accepted standards of syntax
3. If you don't follow standards at least be constent
Anyway

Select code,sum( IF(PASS_FAIL='P',1,0)) 
AS Cp from table group 
INNER JOIN 
(SELECT Sheet1.state, code,Sheet1.address,stdcnt
FROM Table5 Sheet1)
ON Table5.code = Sheet1.centrecode
order by state,stdcnt desc;
 

Something along those lines