search

pbs-assess / data-stewardship-unit

0 stars 0 forks source link

Update Commercial Salmon Catch Query to report on licence areas separately (e.g., gill net D/E) #40

Closed AnnaD-M closed 3 weeks ago

Br-Johnson commented 4 weeks ago

Recreate this part of the opening query:

SELECT
    CASE ol.lic_lic_id
        WHEN 5328 THEN 'Seine A'
        WHEN 5330 THEN 'Seine B'
        WHEN 5332 THEN 'Gillnet C'
        WHEN 5334 THEN 'Gillnet D'
        WHEN 5336 THEN 'Gillnet E'
        WHEN 5338 THEN 'Troll F'
        WHEN 5340 THEN 'Troll G'
        WHEN 5342 THEN 'Troll H'
        ELSE 'Other'
    END AS gear,
Br-Johnson commented 3 weeks ago

Added a new column called 'license type' to the qry_commercial_catch table