CODING IS PL/SQL. How to create a package to show the parliament id based on their gender just like the picture given?

\begin{tabular}{|l|l|l|} \hline & \multicolumn{1}{|c|}{ PARLIAMENT_ID } & \\ \hline P.057 & GENDER \\ \hline P.057 & MALE \\ \hline P.057 & MALE \\ \hline P.057 & MALE \\ \hline P.057 & MALE \\ \hline P.071 & MALE \\ \hline \end{tabular}