Average below the 95th Percentile

Average below the 95th Percentile


If i have numbers 0 through 100, the 95th percentile would be 95.9, so number 96->100 are above the 95th percentile. I would like to exclude everything above 95th percentile and get the average for 0->95.9 which should be 47.5. 

In excel its easy, see below. How do i get average below the 95th percentile in SQL in Zoho? 

Bonus Question:
How can i get a COUNT for all numbers that fall into the 75th percentile? 
I tried this and it doesn't work:
  1.     Count(Percentile("column1", 75) as '# in 75th Percentile', 

                          Zoho Desk Resources

                          • Desk Community Learning Series

                          • Digest

                          • Functions

                          • Meetups

                          • Kbase

                          • Resources

                          • Glossary

                          • Desk Marketplace

                          • MVP Corner

                          • Word of the Day

                              Zoho Marketing Automation

                                      Manage your brands on social media

                                              Zoho TeamInbox Resources

                                                Zoho DataPrep Resources

                                                  Zoho CRM Plus Resources

                                                    Zoho Books Resources

                                                      Zoho Subscriptions Resources

                                                        Zoho Projects Resources

                                                          Zoho Sprints Resources

                                                            Qntrl Resources

                                                              Zoho Creator Resources

                                                                Zoho WorkDrive Resources

                                                                  Zoho Campaigns Resources

                                                                    Zoho CRM Resources

                                                                    • CRM Community Learning Series

                                                                      CRM Community Learning Series

                                                                    • Tips


                                                                    • Functions


                                                                    • Meetups


                                                                    • Kbase


                                                                    • Resources


                                                                    • Digest


                                                                    • CRM Marketplace

                                                                      CRM Marketplace

                                                                    • MVP Corner

                                                                      MVP Corner

                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now