Hello SQL Developers,
I'm new to SQL and need help producing an output for the following:
Get the makers who produce only one product type and more than one model.
Output: maker, type.
The makers values are A,B, C, D and the values for types are PC, Laptop, Printer.
I have been able to get all makers producing more than one model with the below query:
Select maker from Product
Group by maker Having
count(model) > 1
Next step, I'm trying to get all makers producing only one type which I'm not sure and don't know how to combine these two.
Can anyone please help?