Need some help Please

Your question is asking you to learn about using JOINS in order to connect data in different tables in order to satisfy business related questions.

for example:
you might have a table of authors that contains all the information about those authors and you have another table that contains all the information about publishers and another that has information about books.

Every author has an ID in their row in the table, this is their unique identifier, it is special to them and only them. This is a Primary Key. Also in their row is a column called publisher_ref, this is the ID of their publisher. we dont store all the information about the publisher in the Authors table, we have the publishers table for that. Lots of authors will share the same publisher so the publisher_ref will be seen many times in the authors table. This is a foreign key - it is a link to the primary key of another table

Every publisher has an ID in their row in the table, this is their unique identifier, it is special to them and only them. This is the primary key of the publishers table and is in a relationship with the authors table via the relationship of the publishers primary key to the authors foreign key.

We can get information about an author by writing a script that selects information from the authors table:

SELECT a.fname, a.sname, a.dateofbirth, a.state FROM AUTHORS as a

If we want to gather information about authors and publisher we have to JOIN the two tables:

SELECT a.fname, a.sname, a.dateofbirth, a.state, p.publishername  
FROM AUTHORS as a
INNER JOIN publishers as p ON a.publisher_ref = p.publisherID

It is wholly possible to build a string of JOINS to connect information from lots of tables, simply by identifying the relationships and repeating the INNER JOIN line so if there was a titles table and a vendors table we could get information about the books an author has written, who published them, what they were called and where they were sold with a query like:

SELECT a.fname, a.sname, p.publishername, b.title, v.outletname
FROM AUTHORS as a
INNER JOIN publishers as p ON a.publisher_ref = p.publisherID
INNER JOIN titles as t ON p.publisherID = t.publisher_ref
INNER JOIN vendors as v on t.titleID = v.title_ref

Hope this and the other answers have helped to explain the way you need to answer your assignment.

select t.territory_id, t.territory_name
from dbo.territories as t
where exists (select * 
              from dbo.Sales s 
              where s.product_id = 17 --'or whichever one you're looking for, better would be @product_id
              and s.territory_id = t.territory_id
             );

and

select territory_id, salesperson_id, count(*) as Numsales
from dbo.Sales
group by territory_id, salesperson_id;

You may like to join to other tables to get more info:

with groupeddata as (
select territory_id, salesperson_id, count(*) as Numsales
from dbo.Sales
group by territory_id, salesperson_id
)
select g.NumSales, t.territory_name, s.salesperson_name
from groupeddata g
join dbo.territories t on t.territory_id = g.territory_id
join dbo.salespeople s on s.salesperson_id = g.salesperson_id;