add DIPSOSAL and PRESENTATION information to EFALO_SPE

[roimartins]

add DIPSOSAL and PRESENTATION information to EFALO_SPE

[roimartins]

select *
from F_ACTIVITY where VOYAGE_ID = '900047388977'

select * from
F_CATCH where ACTIVITY_ID = '21216578'

with a as (

select * from F_ACTIVITY where year ( ACTIVITY_DATE ) > 2009
) , b as (
select * from
F_CATCH where ACTIVITY_ID IN ( SELECT DISTINCT ACTIVITY_ID from a ) and LIVE_WEIGHT = 0 ) --and DISPOSAL_CODE > 1 and and SPECIES_CODE = 'HER'

select * from b
left join D_DISPOSAL c
on c.DISPOSAL_CODE = b.DISPOSAL_CODE

order by DISPOSAL_CODE

code for this issue

with a as (
select * from
F_CATCH where SPECIES_CODE = 'LBE'
and LANDED_WEIGHT != LIVE_WEIGHT
and LIVE_WEIGHT != 0 )

select AVG ( LANDED_WEIGHT / LIVE_WEIGHT ) from a