Find the albums with 12 or more tracks. Can anyone help me?

Question

I have a set of data in tables consisting of ER diagram and there are relationships between them and some of them
The table of albums and table of tracks, and he asked me the following:
Find the albums with 12 or more tracks.
Can anyone help me?

Answer 1

If i knew what exactly the table looks like i might have helped!

Answer 2

Select from .... where ....
it is almost the same as plain English

Answer 3

pasant Hussein what have you written so far ? Sololearn is a self learning platform and we don't encourage direct answers .

Also you can upload the image on many online sites free or paid and have the link posted here .

you can also post images in your post feed

Answer 4

Yes, because you trying to get only albums' id which higher than or equal to 12!!!!
Instead you need to select album IDs which track amount is higher than or equal to 12

Answer 5

Use count

Answer 6

Have you solved or it is not necessary already? Cuz I have a solution

Answer 7

Where did you get this task?
Is it from SL or it is your school task?

Answer 8

No thanks no nothing... Perfect!!!
I am deleting answer and put you to the black list.

Answer 9

I hope that 🤍

Answer 10

I do not get you
I write that
Select albumid
From tracks
Where albumid >= 12 ;

Answer 11

But it had some thing wrong

Answer 12

But what do you mean by track amount??
Which column did you mean?

Answer 13

I didn't solve it 😔

Answer 14

Please tell me the solution 🤍

Answer 15

It's from Coursera
I am trying to improve my skills by taking more courses

Answer 16

Albums table has :
Albumid (primary key)
Title
Artistid

Tracks table has :
Trackid( primary key )
Name
Albumid
Mediatypeid
Genreid
Composer
Milliseconds
Bytes
Unitprice

I have pictures for the table but i can't put it here