From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Filter data

Filter data

From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Start my 1-month free trial

Filter data

“

- [Instructor] Google BigQuery supports an extensive set of SQL capabilities. The reference for the standard SQL is available in the following website, cloud.google.com/bitquery/docs/reference /standard-sql/querysyntax. Let us explore some key functionality for executing queries in this and the following videos. I will start off by filtering data. We are going to query for a list of patients who are about 40 years of age and whose gender is female, or they drink. We enter the query in the query editor. We can also nicely format it. In the where class, we create the Boolean expression to check for age greater than 40. You can use other comparative operators like equal to, not equal to, and also functions that are done (mumbles) - And and or are the logical operators available, we can use that to check for gender and whether the patient drinks. Let's execute the query and see the results. Note that the query, whatever way you execute, is also stowed in the query history. You can always…

Contents