Hy all!

Can anyone help me in converting my database problem in SQL?

I already tried to solve this problem via Microsoft Access, but unfortunately I'm not very confident with the SQL-language...

Here's my problem for a petshop database, that I have to solve:

ITEM(ItemID, ItemDescription, AnimalCategory)
SALE_ITEM(ItemID, SaleID, Quantity)
SALE (SaleID, Date, CustomerID, EmployeeID)
SALE_ANIMAL (SaleID, AnimalID, SalePrice)
ANIMAL(AnimalID, AnimalName, AnimalCategory, DateBorn, Gender, ListPrice)
CUSTOMER(CustomerID, CustomerName, Address, City, State, Zip)
EMPLOYEE(EmployeeID, EmployeeName)

The pet store sells both items and animals. Information about sold items is in
the SALE_ITEM table. Information about sold animals is in the SALE_ANIMAL table.
The field “AnimalCategory” includes values such as dog, cat, etc.
The SALE_ANIMAL table contains only the animals that have been sold.
The SALE_ITEM table contains only the items that have been sold.
The ANIMAL table contains all the animals, including those that have been sold.
The ListPrice may be different from the SalePrice.


Write the following queries (i.e., a - d) in SQL:
...
12) List the EmployeeIDs of employees who sold at least one animal from every category. Please note: the entire set of categories of animals is in the ANIMAL table.

11) Count the number of male animals in each category, and list a category only if it has more than 10 male animals. The resulting table should have two columns: the first column with the AnimalCategory and the second column with the count within each of the AnimalCategory. (Please note: “Male” is listed in the Gender column)

I would be very if you could help me!!!!!!!
Kind regards Sarah