Is there an “easy” way to run a query on a subset of the data without re-writing the query.
For example, we know that 94.4% of websites use at least one third-party resource (source: Third Parties | 2021 | The Web Almanac by HTTP Archive). If I wanted to re-run this query to find out how many WordPress websites are using at least one third-party resource; would I need to write a new query? Similarly, if I want to run the query on the Top 1,000 sites.
If there are views (referring to SQL Views) which already filter out the data according to some predefined conditions, then I would be able to change the
FROM statement to point to the new table.
I know there is the concept of “lens”, but I’m not sure how it can be applied. Thanks