*There are three statuses 0=Initiated, 1=In Progress, 2=Completed
I need a query to get the result rows as per below:
-----------------------------------------------------------------------
VEHICLE_CLASS_NAME | COMPLETED_ VEHICLES | NOT_COMPLETED_ VEHICLES
---------------------------------------------------------------------------
ABC | |vehicle_001, vehicle_004, vehicle_006
BCD | vehicle_005 |vehicle_002
EFG | vehicle_003 |
* If Status=2 then completed else it is not completed.
Please see attached image to view tables.
Please help me, how can I get result rows.
Thank you.