Please help me with these two SQL queries

1. Give a list of Manufacturer names and IDs for manufacturers which only provide products valued over $30, i.e. whose cheapest product's list price is over $30. (Hint: Use a correlated subquery)

2. Give a list of customers (IDs and Names) whose purchases during the month of January 2014 were always the same color. (Hint: Use a single correlated subquery with joins, and count distinct colors of purchased products)

Customer CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone Manufacturer ManufacturerID ManufacturerName Address1 Address2 City State PostalCode Phone Product ProductID ProductName ManufacturerlD Composition ListPrice Gender Category Color Description 1 Contact URL Saleltem Inventoryltem Y ProductID 1 * ProductID Purchaseltem ProductID ItemSize SalelD Quantity SalePrice QtyOnHand ? Purchase!D Quantity PurchasePrice temSize ItemSize Sale SalelD SaleDate CustomerID Tax Shipping Purchase PurchaselD PurchaseDate EmployeelD ExpectedDeliveryDate ManufacturerlD Shipping Employee EmployeelD 1 FirstName LastName Address City State SalaryEmployee EmployeelD Salary WageEmployee EmployeelD Wage MaxHours Phone ManagerlD SSN EmailAddress HireDate Customer CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone Manufacturer ManufacturerID ManufacturerName Address1 Address2 City State PostalCode Phone Product ProductID ProductName ManufacturerlD Composition ListPrice Gender Category Color Description 1 Contact URL Saleltem Inventoryltem Y ProductID 1 * ProductID Purchaseltem ProductID ItemSize SalelD Quantity SalePrice QtyOnHand ? Purchase!D Quantity PurchasePrice temSize ItemSize Sale SalelD SaleDate CustomerID Tax Shipping Purchase PurchaselD PurchaseDate EmployeelD ExpectedDeliveryDate ManufacturerlD Shipping Employee EmployeelD 1 FirstName LastName Address City State SalaryEmployee EmployeelD Salary WageEmployee EmployeelD Wage MaxHours Phone ManagerlD SSN EmailAddress HireDate