Manufacturer(mid: integer, name: string, address: string) Product(pid: integer, pname: string, color: string, country: string) Make(mid: integer, pid:integer, cost: real) The Make () relation lists the prices charged for products by Manufacturers ( ).

For every manufacturer that only manufactures products from Germany, Write an SQL query to print the name of the manufacturer, and the total number of products he manufactures.

Write an SQL query to Print the names of red products from the country of Germany for which there is some manufacturer .