I have two tables. Here are the descriptions:
School:
mysql> describe School;
+--------------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------------------+-----------------+------+-----+---------+----------------+
| director_id | int(5) unsigned | NO | | |
|
| school_id | int(5) unsigned | NO | PRI | NULL |
auto_increment |
| address | varchar(255) | NO | | |
|
| city | varchar(255) | NO | | |
|
| state | varchar(2) | NO | | |
|
| zip | varchar(20) | NO | | |
|
| school_name | varchar(255) | NO | | |
|
| phone_number | varchar(17) | NO | | |
|
| fax_number | varchar(17) | YES | | NULL |
|
| cell_number | varchar(12) | YES | | NULL |
|
| choir | tinyint(1) | NO | | |
|
| band | tinyint(1) | NO | | |
|
| band_beg_time_req | varchar(13) | YES | | NULL |
|
| band_end_time_req | varchar(12) | YES | | NULL |
|
| choir_beg_time_req | varchar(13) | YES | | NULL |
|
| choir_end_time_req | varchar(12) | YES | | NULL |
|
+--------------------+-----------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)
Entry:
mysql> describe Entry;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| entry_id | int(255) | NO | | 0 | |
| entry_name | varchar(255) | NO | | | |
| entry_type | varchar(10) | NO | | | |
| instrument | varchar(255) | YES | | NULL | |
| entry_class | varchar(12) | NO | | | |
| num_of_part | int(255) | NO | | 0 | |
| school_id | int(5) | NO | | 0 | |
| acc_id | int(5) | NO | | 0 | |
| performance_room | varchar(10) | YES | | NULL | |
| warm_up_room | varchar(10) | YES | | NULL | |
| year | int(4) | NO | | | |
| level | varchar(3) | NO | | | |
+------------------+--------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
Entry.entry_class will either be "Instrumental" or "Vocal". I need a
query that will select School.school_name, and the counts for each
entry_type (there are Solo, Ensemble, and Choir/Band) for ONLY a
particular entry_class (be it Instrumental or Vocal).
-Michael Sullivan
