Extracting Statistical Data out of a Non-Numeric Field

SELECT MIN(vendor_name) AS first_vendor,

MAX(vendor_name) AS last_vendor,

COUNT(vendor_name) AS number_of_vendors

FROM vendors

The Output for this Query

Here we are using the String Variable field vendor_name but we can still extract numerical metadata from it

First Vendor Name Based on default index

Last Vendor Name Based on default index

The Number of Vendor Records in the Table