SQL Syntax to count number of instances in the database

Is SeatsId the number of seats they requested, or would there be 5 records if they requested 5 seats?

If it is the latter, you would do

select count(userID)
from trainingdates
where roomId = <selected room id>
and dateid = <selected date>

If it is the former, you would do

select sum(seatsid)
from trainingdates
where roomId = <selected room id>
and dateid = <selected date>

if a user selected 5 seats there would be 5 records... one record for each seat
IE
USERID     ROOMID  DATEID  SEATID
1               1              1           1-1
 1              1              1           1-2

ect ect

There is also a primary key that autogenerated  when this infor is inserted into the   database called USERRAININGDATEID so

USERTRINAINGDATEID     USERID     ROOMID  DATEID  SEATID
            1                              1               1              1          1-1
            2                             1              1              1           1-2
            3                             1              1              1           1-3

which would you go with  now ?
======================================================
also  how about a separate  query to also produce the list of each seat in that instance so I can whip something up to grey out that seat number when they select that day

(if you wnat me to post that as a separate question I will :) )
 

select seatid
from trainingdates
where roomId = <selected room id>
and dateid = <selected date>

that will return each seat  IE 1-1 1-2 and 1-3

SELECT CASE WHEN 50 - COUNT(*) >= @askedNumberOfPlace THEN 'Approved' ELSE ' END
FROM trainingdates
WHERE roomid= @askedRoomID
AND dateid= @askedDateID

plusone:

yes that will return each seat.

thank you for all your assistance