-- two minus signs start a comment


-- prepare
drop table if exists student;


create table student (ssn fixed, name char(20));

insert into student values(123, "Smith");
insert into student values(234, "Tompson");
insert into student values(345, "Atkinson");

-- see what we have inserted
select * from student;


-- beautify the output
.echo ON
.headers ON
.mode column


-- again, see what we have inserted
select * from student;



-- register students in classes and give them grades
drop table if exists takes;
create table takes (ssn fixed, cid char(10), grade fixed);
insert into takes values( 123, "db", 4);
insert into takes values( 123, "os", 3);
insert into takes values( 345, "os", 3);
insert into takes values( 345, "graphics", 4);


-- see what we inserted
select * from takes;
