For each query, show the SQL code:

1. How many courses start before 12:00?

__________________________________

Create a new table called SPR_COURSES which has the following fields:

Subject CHAR(3)

Course CHAR(3)

Section CHAR(2)

Credits CHAR(5)

Title VARCHAR(16)

Days VARCHAR(5)

Time CHAR(17)

Instructor VARCHAR(32)

Location VARCHAR(16)

The data for this table will have to be done using the following INSERT command. You just have to copy and paste this command into the SQL window and then click go.

INSERT INTO SPR_COURSES

VALUES

('CIS', 106,2,3,'End-User Computg', 'TR', '08:00 am-09:15 am', 'Robert S. Winter', 'DRAKE 0044'),

('CIS', 106,3,3,'End-User Computg', 'TR', '11:00 am-12:15 pm', 'Timothy P. Mullins', 'DRAKE 0044'),

('CIS', 106,4,3,'End-User Computg', 'TR', '03:30 pm-04:45 pm', 'Robert S. Winter', 'DRAKE 0044'),

('CIS', 106,5,3,'End-User Computg', 'TR', '05:00 pm-06:15 pm', 'Robert S. Winter', 'DRAKE 0044'),

('CIS', 106,6,3,'End-User Computg', 'M', '05:05 pm-07:50 pm', 'Barry C. Chow', 'DRAKE 0044'),

('CIS', 106,7,3,'End-User Computg', 'W', '05:05 pm-07:50 pm', 'Barry C. Chow', 'DRAKE 0044'),

('CIS', 106,8,3,'End-User Computg', 'MWF', '08:00 am-08:50 am', 'Donna J. Ehrhart', 'DRAKE 0044'),

('CIS', 202,1,3,'Fund Of Info Sys', 'TR', '03:30 pm-04:45 pm', 'Anthony Scime', 'HOLMES 0204'),

('CIS', 206,1,1,'IT Tools', 'M', '05:05 pm-07:00 pm', 'Kadathur B. Lakshmanan','DRAKE 0030'),

('CIS', 303,1,3,'Inf Tech Hdw Sft', 'MWF', '11:15 am-12:05 pm', 'Anthony Scime', 'DAILEY 0205'),

('CIS', 305,1,3,'Web Design & Pub', 'MWF', '09:05 am-09:55 am', 'Donna J. Ehrhart', 'DRAKE 0044'),

('CIS', 421,1,3,'Cmptr & Net Sec', 'TR', '09:30 am-10:45 am', 'Vishal Anand', 'EDWARD 0107'),

('CIS', 422,1,3,'Desgn/Imple Dbms', 'MWF', '09:05 am-09:55 am', 'T M. Rao', 'DAILEY 0201'),

('CIS', 427,1,3,'Proj Mgmt &Pract', 'MWF', '12:20 pm-01:10 pm', 'Mehruz Kamal', 'HOLMES 0203'),

('CIS', 487,1,3,'IT for DEV', 'MWF', '10:10 am-11:00 am', 'Mehruz Kamal', 'HOLMES B0002'),

('CIS', 492,1,3,'CIS Internship', 'MWF', '08:00 am-08:50 am', 'Mehruz Kamal', 'HARTWL 0002'),

('CSC', 120,1,3,'Intro Comp Sci', 'MWF', '10:10 am-11:00 am', 'Kulathur S. Rajasethupathy','DAILEY 0205'),

('CSC', 120,2,3,'Intro Comp Sci', 'MWF', '09:05 am-09:55 am', 'Kadathur B. Lakshmanan','TUTTLS 0257'),

('CSC', 203,1,4,'Fund Comp Sci I', 'MW', '03:35 pm-04:50 pm', 'Sandeep R. Mitra', 'TUTTLS 0257'),

('CSC', 203,2,4,'Fund Comp Sci I', 'TR', '05:00 pm-06:15 pm', 'Kadathur B. Lakshmanan','EDWARD 0101'),

('CSC', 205,1,4,'Fund Comp Sci II', 'MW', '03:35 pm-04:50 pm', 'T M. Rao', 'ALLEN 0106A'),

('CSC', 209,1,1,'UNIX Tools', 'W', '05:05 pm-07:00 pm', 'T M. Rao', 'DRAKE 0030'),

('CSC', 303,1,3,'Dgtl Cmptr Desgn', 'TR', '03:30 pm-04:45 pm', 'Vishal Anand', 'EDWARD 0107'),

('CSC', 311,1,4,'Comp Org SW Intf', 'TR', '05:00 pm-06:15 pm', 'Daniel F. Rogers', 'DAILEY 0201'),

('CSC', 406,1,3,'Algor&Data Struc', 'TR', '02:00 pm-03:15 pm', 'Joan M. Lucas', 'ALLEN 0106A'),

('CSC', 412,1,3,'Operating Systms', 'TR', '12:30 pm-01:45 pm', 'Vishal Anand', 'ALLEN 0106A'),

('CSC', 421,1,3,'Cmptr & Net Sec', 'TR', '09:30 am-10:45 am', 'Vishal Anand', 'EDWARD 0107'),

('CSC', 422,1,3,'Relational Db', 'MWF', '09:05 am-09:55 am', 'T M. Rao' , 'DAILEY 0201'),

('CSC', 429,1,3,'Obj Ori Soft Dev', 'MWF', '11:15 am-12:05 pm', 'Sandeep R. Mitra', 'DAILEY 0201'),

('CSC', 483,1,3,'Theory Computatn', 'MWF', '12:20 pm-01:10 pm', 'Daniel F. Rogers', 'TUTTLN B0225'),

('CSC', 486,1,3,'Jun/Sen Seminar', 'TR', '05:00 pm-06:15 pm', 'Timothy P. Mullins', 'TUTTLN B0226'),

('CSC', 492,1,3,'Internship', 'TR', '08:00 am-09:15 am', 'Mehruz Kamal', 'HARTWL 0032');