How to Find Top X% or Bottom X%?

What are the top 5% of store customers with the most orders? What are the bottom 10% of the worst performing store locations? A data scientist should know how to retrieve this information from a dataset and report the results. And since in many cases, the data are stored in the form of a relational database, it is helpful to know how to use SQL for finding filtering percentiles.