SQL guides

Each guide solves one task on open_ef.factors_flat, shows the result, and names the column rule that makes the answer safe. Most pages are a single query; a few add a second one to check the first, and the quickstart walks several. Every query on these pages is executed against the live data before the page is published, so you can paste it as is. What you paste it into is a connection you arrange, and the copy you get can sit behind the website.

Pick the page whose title matches the question you have in hand. If you are new to the view, start with Quickstart: SQL and The model at a glance, then come back. If a guide warns about a rule you do not recognise (a default row, a top parent, a GWP basis), the linked data-model page explains it once for all guides.