Hi
It's basically one answer to both your questions ...
What you get with Smartform is data - a MySQL database to be specific. There are four main tables in it. "Historic races" and "Historic runners" give full details of all past UK and Irish races, and individual runner performances within them, going back at least 10 years. "Daily races" and "Daily runners" give details for declarations made before races are run. Both are updated overnight - the 'historic' tables with the previous day's results and the 'daily' tables with the following day's declarations.
What you don't get is any kind of graphical user interface / dashboard / control panel for querying the data. It's not that kind of service. It's designed for people who purely want the data to use as an input to their own programs, solutions and analyses.
You can therefore do virtually anything with the data. All of the analyses and extracts that you ask about are completely feasible. The only limitation is your own programming and analytical skills. These will need to begin in MySQL but extend to whatever other products you intend to use.
For what it's worth I use MySQL Workbench (open source GUI for MySQL) to manage the database, a combination of R and MS Excel for my data analysis, and a bot written in MS Visual Basic to automate my Betfair betting.
For what it's worth I can heartily recommend the Smartform data service and have subscribed to it for several years now.
Good luck
