-- Create and populate Students table.

create table students(
    id integer primary key not null,
    lname varchar(15),
    fname varchar(15),
    gender varchar(1),
    bdate date,
    year integer,
    major varchar(10),
    fulltime integer,
    gpa real,
    email varchar(20));

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values (36544, 'Hubert', 'Julie', 'F', 
        '1993-10-5', 3, 'Sociology', 1, 3.58, 
        'julieh@qmail.org');

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values (84379, 'Rutger', 'David', 'M', 
        '1992-2-23', 4, 'Art', 1, 2.89, 
        'davidr@qmail.org');

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values (23477, 'Rao', 'Tanya', 'F', 
        '1989-12-26', 4, 'English', 1, 3.78, 
        'tanyar@qmail.org');

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values (21289, 'Williams', 'Carolyn', 'F',
        '1994-6-4', 1, 'Accounting', 1, 3.48,
        'carolynw@qmail.org');
    
insert into  
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values (63745, 'Miller', 'Thomas', 'M', 
        '1993-11-30', 3, 'Sociology', 1, 3.21,
        'thomasm@qmail.org');

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values(70341, 'Chen', 'Sherry', 'F',
        '1994-2-19', 2, 'Accounting', 1, 3.98,
        'sherryc@qmail.org') ;

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values(38273, 'Ward', 'Alice', 'F',
        '1991-4-27', 3, 'Sociology', 0, 3.50,
        'alicew@qmail.org');

insert into  
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values(38827, 'Suarez', 'Francis', 'M',
        '1984-10-21', 1, 'Sociology', 1, 3.22,
        'franciss@qmail.org');

insert into 
    students (id, lname, fname, gender, bdate,
        year, major, fulltime, gpa, email)
    values(95736, 'Miller', 'Alice', 'F',
        '1995-6-11', 1, 'Accounting', 1, 3.67,
        'alicem@qmail.org');

select * from students;