Count and add up in SQL

The steps

The exact sequence, in order.

1. 01

   Type SELECT store, COUNT(*) AS n, SUM(amount) AS total

2. 02

   Then FROM sales and GROUP BY store

3. 03

   Then ORDER BY total DESC LIMIT 3;

4. 04

   Shift + Enter: Lyon Croix-Rousse, 42 sales, 2016.0. The same numbers as with Python.