Find the total number of registered authors, the percentage of them who have a website URL containing ".com", and the percentage who have never made a sale.
Use the authors and sales tables. Return one summary row with the requested totals and percentages.
total_registered_authors, pct_with_com_website, pct_never_made_sale| Column | Type | Description |
|---|---|---|
| author_idPK | INT | Unique registered author identifier |
| author_name | VARCHAR(100) | Author display name |
| website_url | VARCHAR(255) | Optional author website URL |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| author_id | INT | Author associated with the sale |
| sale_amount | DECIMAL(10,2) | Amount collected for the sale |