| create or replace view v18 as select pageRank, pageURL, avgDuration from `dfs/parquet/rankings`; | |
| create or replace view v18_2 as select sourceIP, destinationURL, visitDate, adRevenue, userAgent, countryCode, languageCode, | |
| searchWord, duration from `dfs/parquet/uservisits`; | |
| select * from v18 inner join v18_2 on v18.pageURL = v18_2.destinationURL; | |
| drop view v18; | |
| drop view v18_2; |