Texts: 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 they manufacture.