farhaduneci

-- Case Study #1 - Danny's Diner
-- https://8weeksqlchallenge.com/case-study-1/
-- Solved on SQLite 3.39 by Farhad Uneci, August 2022

-- 1. What is the total amount each customer spent at the restaurant?
SELECT
    customer_id AS 'Customer',
    SUM(price) AS 'Paid'
FROM
    sales