Your question is Meta SQL: Author Domain Pattern. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Meta's creator publishing analytics team wants to identify prolific authors and measure how many registered authors have websites associated with the meta.com domain. Write a PostgreSQL query using the authors and books tables.
meta.com, ignoring letter case.| Column | Type | Description |
|---|---|---|
| author_idPK | INT | Unique author identifier |
| author_name | VARCHAR(100) | Author's display name |
| is_registered | BOOLEAN | Whether the author is registered |
| website_url | VARCHAR(255) | Personal website URL |
| Column | Type | Description |
|---|---|---|
| book_idPK | INT | Unique book identifier |
| author_id | INT | References authors.author_id |
| title | VARCHAR(200) | Published book title |