Imported CSV: Right Join
In this mini-project, I created two CSV files and uploaded them to BigQuery. I then performed analysis using a right join in SQL.
File Creation
I began by creating two simple CSV files—one with first names, ages, and occupations of fictitious people, and the other with their colleges and graduation years where applicable (along with their first names).
File Import & Validation
I then uploaded the files to BigQuery, adding them to a blank dataset I created within a personal folder. I checked the schema and tables themselves to ensure that the files imported correctly for analysis.
Query
I then queried the dataset for first names, ages, and graduation years, using a RIGHT JOIN clause to return records for only the people with associated data in the college table. I sorted the records in ascending order by age.