1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
1 Oracle General 37422. Display the post code and the total number of purchase orders placed with creditors in that post code.
Oracle General 16063. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Oracle General 17754. Using a set operator, display the creditor number of all creditors who have ever been paid.
2 Oracle General 39725. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
6 Oracle General 6020