I have in my DB the following relation:
It describes the subscribers to magazines ("title"), with the primary key "cid" - customer id. The other relations here are not relevant.
This is the code I run, the find all the customers (cid) that have a subscription to only one magazine:
select count(cid), cid
from subscribes as r1
group by cid
How do I find that one magazine, that these customers are subscribed to?
I tried just adding the "title" column to the code, and it gave me all the titles, with a $1$ on the left column of count.