| SELECT actor_name,
COUNT(*) AS "Year total",
SUM(CASE WHEN... |
2 years ago |
| SELECT actor_name,
COUNT(*) AS "Year total",
SUM(CASE WHEN... |
2 years ago |
| SELECT actor_name,
COUNT(*) as "Year total",
SUM(IF... |
2 years ago |
| SELECT COUNT(*), SUM(page_len) / COUNT(*) AS "Average Size", actor_name
FROM... |
2 years ago |
