The Quantity of things in one table

Question

I have got two different tables

dogs (id , name)
dogs_pref (id_dog, preference(only one) )
preferences (one dog can have 0 , 1 , 2 preferences in text format)

The task is creating two different requests

1st : Create the request which showed dogs with preferences (one or more) 2nd : Create the request which showed quantity of preferences per dog

1st:

SELECT dogs.Name, dogs_pref.id_dog, dogs_pref.preference
FROM dogs
LEFT JOIN dogs_pref
ON dogs.Id=dogs_pref.id_dog
where dogs_pref.preference >= 1
ORDER BY dogs.Id;

2nd:

Here is the big question how to write it in simplest way ????

You say you have two tables, and you list three. Please clarify. — P. Camilleri, Apr 24 '14 at 10:07
Based on my experience in the OP's previous question, this is going to lead to a world of pain. — MatBailie, Apr 24 '14 at 10:09
MatBailie, do not worry . Everything is good :) I have got two tables - dogs and dogs_pref. Preferences is an explanation of column of 2nd table — user2451093, Apr 24 '14 at 10:15
So don't put three bullet points in your list, last one should be separated from the others. Presenting this way is confusing. — P. Camilleri, Apr 24 '14 at 10:20

score 0 · Answer 1 · answered Apr 24 '14 at 10:11

0

SELECT dogs.id, sum(to_number(dogs_pref.preference))
FROM dogs
LEFT JOIN dogs_pref
ON dogs.Id=dogs_pref.id_dog
group by dogs.id;

answered Apr 24 '14 at 10:11

Olesya Razuvayevskaya

1,148
1
7
10

The Quantity of things in one table

1 Answers1