Please Help with advanced sql query
I have a database that shows seat utilisation in a computer class. We hold 3 sessions daily, ie am, pm, evening. On the booking they can book for any seesion and have a seat also a seat number 1 -8. I want to be able to create a query that will eventually show up on a web page , which shows that session = am has some seats booked and some available. The session data lies in a session_booking table, that contains the following columns.
Session_date, Session _name, seat number, booked by
01/04/2003, am, 1, voucher
01/04/2003, pm, 5, voucher
01/04/2003, evening, 3, Club
I dont really want to re-organise the table.
I would like this solved sharply as i have been at it for about 3 weeks.