Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;

ERROR:  column "version" does not exist
LINE 1: select @@version;
                 ^


CREATE TABLE manufacturer_status (
    Organization VARCHAR(100),
    Year INT,
    Target VARCHAR(50)
);

CREATE TABLE


INSERT INTO manufacturer_status (Organization, Year, Target)
VALUES
    ('ABC', 2012, 'Achieved'),
    ('ABC', 2014, 'Partial'),
    ('ABC', 2015, 'Failed'),
    ('XYZ', 2014, 'Partial'),
    ('XYZ', 2015, 'Failed'),
    ('OPQ', 2012, 'Failed');

INSERT 0 6


select * from manufacturer_status ;


organization
year
target


ABC
2012
Achieved

ABC
2014
Partial

ABC
2015
Failed

XYZ
2014
Partial

XYZ
2015
Failed

OPQ
2012
Failed



SELECT 6


SELECT DISTINCT ON (Organization) 
    Organization,
    Year,
    Target
FROM manufacturer_status
WHERE Target IN ('Achieved', 'Partial')
ORDER BY Organization, 
    CASE 
        WHEN Target = 'Achieved' THEN 1
        WHEN Target = 'Partial' THEN 2
    END;


organization
year
target


ABC
2012
Achieved

XYZ
2014
Partial



SELECT 2

organization	year	target
ABC	2012	Achieved
ABC	2014	Partial
ABC	2015	Failed
XYZ	2014	Partial
XYZ	2015	Failed
OPQ	2012	Failed