I have two questions left for an assignment and I can not figure them out.
Here they are:
List the territory_id and the territory_name of all territories where end tables have been sold.
List the total sales for each sales territory by salesperson.
Any advise would be greatly appreciated.
I dont even know how to start these...I have completed the rest of my assignment...The problem with the first one is there is not a territory_id or territory_name under the order table so Im supposed to use a bunch of different tables...
I believe I am supposed to look at the order_line_t table then see if there is any end tables sold...but my problem comes when There is no territory_id in order_line_t or Order_t...Its only in does_business_in_t or territory_t.