SQl query to join a table with Attributes in different rows and filter values

I am pretty new to SQL and actually a C# programmer. I have been given a table with PartNumbers that have different attribute Names and Values. The objects would have a class like car, truck, jeep etc... & each class would have different attributes like Milage for CAR & tonnage for Trucks. Each Partnumber may have multiple revisions and the attribute values for these revisons can change.

I would like to query the table for latest revision of the class.

Could someone please help. I have tried multiple options by googleing. May be my dumb brain could not get it right.

ORIGINAL DATABASE TABLE:

NEED TO QUERY FOR CLASS, SAY EG. 'TRUCK' & GET ONLY THE LATEST REVISION OF ALL TRUCKS

SAY I QUERY FOR CLASS 'CAR'

PLEASE NOTE THAT THE ATTRIBUTES DIFFER FROM CLASS TO CLASS

Thanks a lot in advance.

SQL Query to get latest revision from Table with different attributes

Here's what I have tried. Using SQL I first queried the attributes of a single class i needed to get. for eg. CAR using :

SELECT distinct attr_name FROM data WHERE partnumber =(SELECT partnumber FROM data WHERE attr_val  = 'CAR' GROUP BY partnumber LIMIT 1);

then using the list of attributes i Got, I create an SQL string programmatically to query like :

SELECT distinct A0.partnumber,A0.rev,A0.attr_val as "Class",A1.attr_val as "Milage",A2.attr_val AS "Seats"
FROM data as A0,data as A1,data as A2
WHERE A0.attr_name = 'Class'
AND A0.attr_val = 'CAR'
AND (A1.attr_name = 'Milage'
and A1.partnumber = A0.partnumber
AND A1.rev =A0.rev)
AND (A2.attr_name = 'Seats'
AND A2.partnumber = A0.partnumber
AND A2.rev = A0.rev);

I get the following Result:

For anyone looking for a similar Issue...Here is How I achieved my results.

select partnumber,max(rev),Milage, Seats from (
select partnumber,
       rev,
       'CAR' as class,
       max(case when attr_name = 'Milage' then attr_val end) as Milage,
       max(case when attr_name = 'Seats' then attr_val end) as Seats
 FROM data t
 WHERE exists (select 1 from data tt 
               where t.partnumber = tt.partnumber
                 and tt.attr_name = 'Class'
                 and tt.attr_val = 'CAR'
           )
GROUP BY partnumber, rev)
GROUP BY partnumber;

Thank You @ORA-01017 for guiding me in the right Direction.