So, I'm learning SQL and one of my practices is to,

" Determine what departments are in each of the 4 regions. That is, what are the names of the departments that reside in each of the regions."
So basically it wants me to list the departments in each region.

However, I'm just really confused as to where to start.
This is what the tables look like that it could possibly be drawn from...

Regions
region_id
region_name

Departments
department_id
department_name
manager_id
location_id

Locations
location_id
street_address
postal_code
city
state_province
country_id

Countries
country_id
country_name
region_id

Does anyone have any guesses on what to do/ where to start?

SELECT R.region_name,D.department_id,D.department_name FROM regions AS R
   LEFT JOIN countries AS C ON C.region_id = R.region_id
  LEFT JOIN locations AS L ON C.country_id = L.country_id
   LEFT JOIN departments AS D on D.location_id = L.location_id;

Looks like it would work

Hey, I'm new to using sql*plus (I'm learning it at uni)
the tables im working with are structured in the following way:

Suppliers Table has fields:
"SuppCode" and "SuppName"

Stocks Table has fields:
"StoreCode", "Description", "Quantity", "Units", "ReorderLevel", "Price", "SuppCode"

I have to write a query which displays the SuppName for all the suppliers which supply at least 4 stores.

I already have the following part-query which displays the SuppCode for the correct Suppliers, but I don't know how to then display the SuppName for the corresponding SuppCode's.

My query so far is:

Select SuppCode, COUNT(Distinct StoreCode)
From Stocks
Group By SuppCode
Having COUNT(Distinct StoreCode) >= 4;

Any help/hints would be greatly appreciated. Thanks in advance, Simon