Given a table with duplicate data, how would you extract only specific rows based on business requirements provided?

[Hyder_Zaidi]