Spark SQL Basics

SELECT category,
       COUNT(*) AS line_items,
       SUM(amount) AS revenue
FROM sales
GROUP BY category
ORDER BY revenue DESC;

SQL editor. Press Command or Control plus Enter to execute. Suggestions appear as you type; use the arrow keys to choose one and Enter or Tab to insert it, or Escape to dismiss.