SQLQuokkaSQLQuokkaThe publishing team wants a one-row health snapshot of its author roster. Every author in authors counts, including those with no books. An author has a .com website when website_url contains the text '.com' anywhere (all URLs are stored in lowercase). An author has never sold a book when none of their books appear in sales, which includes authors with no books at all. Write an SQL query that returns total_authors, pct_dotcom_website and pct_never_sold, with both percentages rounded to 2 decimal places.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.