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.