Selecting the Maximum Address Sequence Number and Vendor ID: A Comprehensive Guide to SQL Query Solutions