What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Adding code

What did you learn from the changes you have made?

Unit4 & Unit5

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

Yes.

-- Highest total sales
SELECT
market_date,
SUM(quantity * cost_to_customer_per_qty) AS total_sales
FROM
customer_purchases
GROUP BY
market_date
ORDER BY
total_sales DESC
LIMIT 1

UNION

-- Lowest total sales
SELECT
market_date,
SUM(quantity * cost_to_customer_per_qty) AS total_sales
FROM
customer_purchases
GROUP BY
market_date
ORDER BY
total_sales ASC
LIMIT 1

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

Yes. I got below error for above approach.

Execution finished with errors.
Result: ORDER BY clause should come after UNION not before

How were these changes tested?

Yes. SQLite

A reference to a related issue in your repository (if applicable)

None

Checklist

• I can confirm that my changes are working as intended

None