Product
Explore
SQL Editor
Data catalog
Query variables
Collaborate
Shared queries
Search
Version history
Visualize
Dashboards
Charts
Notebooks
Connect
Connections
Scheduled queries
dbt
Resources
Changelog
Blog
Docs
Customers
Tutorials
Templates
Buyers' guide
Pricing
Contact
Sign In
Get Started
Sign In
PopSQL
Product
Explore
SQL Editor
Data catalog
Query variables
Collaborate
Shared queries
Search
Version history
Visualize
Dashboards
Charts
Notebooks
Connect
Connections
Scheduled queries
dbt
Resources
Changelog
Blog
Docs
Customers
Tutorials
Templates
Buyers' guide
Pricing
Get Started
BigQuery
Basics
Get Started with BigQuery and PopSQL in 5 Minutes
Accessing BigQuery Public Datasets
Data Types
Database Management
How to Create a Table
How to Drop a Table
How to Rename a Table
How to Duplicate a Table
How to Add a Column
How to Drop a Column
Dates and Times
Date and Time Data Types
How to Query Date and Time
How to Group by Time
How to Round Timestamps
Analysis
How to Measure Cohort Retention
How to Write a Common Table Expression
How to Generate Series to Avoid Gaps in Data
How to Calculate Percentiles
How to Use countif to Have Multiple Counts
Ready for a modern SQL editor?
Get started for free