Display the supplier name (SupName) and purchase date (PoDate) for all suppliers despite if an order was ever purchased through the supplier or not. Sort the results on supplier name in alphabetic order.

Display ONLY the supplier name (SupName) who has the most orders in Purchase_Order table.

 

PF* SUPNR PF* PRODNR P P PURCHASE_PRICE DELIV_PERIOD F SUPPLIES_PK (SUPNR, PRODNR) SUPPLIES IBFK_1 (SUPNR) SUPPLIES IBFK_2 (PRODNR) * SUPNR * SUPNAME SUPPLIES SUPADDRESS VARCHAR2 (4 BYTE) VARCHAR2 (6 BYTE) * PONR PODATE NUMBER (8,2) NUMBER (11) SUPCITY SUPSTATUS SUPPLIER_PK (SUPNR) * SUPNR SUPPLIER PURCHASE ORDER VARCHAR2 (4 BYTE) VARCHAR2 (40 BYTE) VARCHAR2 (50 BYTE) VARCHAR2 (20 BYTE) NUMBER (11) VARCHAR2 (7 BYTE) DATE VARCHAR2 (4 BYTE) PURCHASE_ORDER_PK (PONR) PURCHASE_ORDER_IBFK_1 (SUPNR) P U * PRODNR PRODNAME PRODTYPE PRODUCT AVAILABLE_QUANTITY PRODUCT_PK (PRODNR) UC1 (PRODNAME) UC1 (PRODNAME) PF* PONR * PF PRODNR PO_LINE VARCHAR2 (6 BYTE) VARCHAR2 (60 BYTE) VARCHAR2 (15 BYTE) NUMBER (11) VARCHAR2 (7 BYTE) VARCHAR2 (6 BYTE) NUMBER (11) QUANTITY PO_LINE_PK (PONR, PRODNR) PO_LINE_IBFK_1 (PONR) PO_LINE_IBFK_2 (PRODNR)