SQL

1) Which suppliers did the pet store NOT buy merchanidise from during August?

2) Which supplier has received the most money from the PetStore (total value) for dog merchandise?

Adoption Group AdoptionID AdoptionSource Contact Name Contact Phone Breed Category Breed Employee Animal Animali Name Category Breed DateBorn Gender Registered Color Photo Image File Imageheight Image Width AdoptionID SaleID Donation City Category Category Registration Supplier Suppliers Name ContactName Phone Address ZIP Code CityID CityID ZIP Code City State AreaCode Population 1990 Population 1980 Country Latitude Longitude Employeeld LastName First Name Phone Address ZIP Code CityID TaxPayerID Date Hired Date Released Manager ID EmployeeLevel Title Sale SalelD SaleDate Employeeld CustomerlD Sales Tax Customer Customer Phone First Name LastName Address ZIP Code CityID Orderitem Merchandise Saleltem MerchandiseOrder PONumber Order Date ReceiveDate SupplierID Employeeld Shipping Cost PONumber ItemID Quantity Cost ItemID Description QuantityOnHand List Price Category SaleID ItemID Quantity Sale Price