-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL
);
create table hospitals (
    id integer primary key ,
    name text not null,
    town text not null 
    );
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
insert into students values (3,'Sophie','F');
insert into students values (4,'Sandra','F');
insert into students values (5, 'Jean','M');

insert into hospitals values (1,'Mercy','Silverspring');
insert into hospitals values (2,'Georgetown','Washington D.C.');
insert into hospitals values (3,'Mercy','Santa Monica');
insert into hospitals values (4,'Mercy','Beverly Hills');
    
-- fetch some values
SELECT * FROM students WHERE gender = 'F' or gender = 'M';
select * from students where name = 'Joanna';
select * from students ;
select * from hospitals ;