| create or replace view v14 as select * from `dfs/parquet/rankings`; | |
| create or replace view v14_2 as select * from `dfs/parquet/uservisits`; | |
| select count(*) from v14 inner join v14_2 on v14.pageURL = v14_2.destinationURL; | |
| drop view v14; | |
| drop view v14_2; |