Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time
drop table tickets;
CREATE TABLE tickets (
infraction_date date,
time_of_infraction integer,
infraction_code integer,
infraction_description text,
fine_amt integer,
location1 varchar(10),
location2 varchar(50),
province varchar(5)
)
;
CREATE INDEX tickets_loc ON tickets (location2);
CREATE INDEX tickets_code ON tickets (infraction_code);
ANALYZE tickets (location2);
ANALYZE tickets (infraction_code);
select * from tickets limit 10