We wish to generate the common summary statistics for all columns in a data frame, such as quantiles for numeric columns and unique value count for non-numeric columns. While we can compute each of those statistics for each column of a data frame individually, it would be efficient during data inspection to use a function that given a data frame computes the common statistics appropriate for the column’s data type.
Unfortunately, there is no efficient and neat way of doing this in sql. We can write a very complex sql procedure that can do this, but we recommend doing this in R or Python. For more details please see Data Frame Summary In Python and Data Frame Summary In R