Помогите, пж, решить задачу по сортировке в sql:


Please return one row per vendor, which represents the vendor's oldest invoice (the one with the earliest date).
Each row returned should include the following columns:

key T1.vendor_id= T2.vendor_id

## - "vendor_name" table T1
## - "invoice_number" table T2
## - "invoice_date" table T2
## - "invoice_total" table T2

Please sort the result set by "vendor_name" in ascending order.


Спасибо!!!