select column1 , column2 , column3 ,column4 from table_name where column4 like 'P%'
Union All
select column1 , column2 , column3 ,column4 from table_name where column4 like 'P%'
Union All
select column1 , column2 , column3 ,column4 from table_name where column4 like 'A%'
Union All
select column1 , column2 , column3 ,column4 from table_name where column4 like 'A%'
order by column1 desc , column2 , column3 ,column4