error Every derived table must have its own alias

[kkshansid]

query 1=SELECT institute.state, result. * 
FROM institute
INNER JOIN result ON centrecode = original_c

then i want to execute query on table 1

SELECT state, sum( IF( PASS_FAIL = 'P', 1, 0 ) ) AS tp from query1
group BY state

but when i execute it gives error

Error
SQL query:  

SELECT state, sum( IF( PASS_FAIL = 'P', 1, 0 ) ) AS tp
FROM (


SELECT institute.state, result. * 
FROM institute
INNER JOIN result ON centrecode = original_c
)
group BY state
LIMIT 0 , 30 

MySQL said:  

#1248 - Every derived table must have its own alias

kindly help me to correct it

[SLauren]

You can try like:

SELECT state, sum( IF( PASS_FAIL = 'P', 1, 0 ) ) AS tp 
FROM ( 
  
  
SELECT inst.state, res. *  
FROM institute inst
INNER JOIN result res ON inst.centrecode = res .original_c 
) 
AS val
group BY state 
LIMIT 0 , 30;