I am batting way out of my league here, but I'm giving it a good try (5 hours of trying so far). Using MariaDB. My problem is my lack of syntax knowledge with SQL

My objective: display a *total products sold* from each *category* constrained by *date range*.

I believe that I need to build a query that will output `|categories_name|SUM(products_quantity)|` `BETWEEN` a date range and `GROUPed BY categories_name`. (I could be wrong)

The data I need is spread across 5 tables:

```
tbl_orders
orders_id   date_purchased
1           1900-01-01
2           1900-01-02
3           1900-01-03

tbl_orders_products
orders_id   products_id   products_quantity
1           100           5
1           200           2
2           100           1
3           100           1
3           300           2
3           400           1

tbl_products_to_categories
products_id   categories_id
100           10
200           20
300           30
400           40

tbl_categories
categories_id   parent_id
10              50
20              60
30              70
40              80

tbl_categories_description
parent_id   categories_name
50          categoryA
60          categoryB
70          categoryC
80          categoryD

```

I have tried so many variations of SQL that I don't even know which one to post here, lest I lead a more knowledgeable person down the wrong path. How (if it's even possible) could I retrieve the output that I'm looking for? I have had success doing an `INNER JOIN` and making a 3-table query work, but this is baffling me. Should I just take a college SQL class before I even attempt this?