1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
1 Oracle General 37282. Display the post code and the total number of purchase orders placed with creditors in that post code.
Oracle General 15963. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Oracle General 17734. Using a set operator, display the creditor number of all creditors who have ever been paid.
2 Oracle General 39435. 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 5979