SELECT Fname ,  Lname ,  phone FROM Faculty WHERE Sex  =  'F'
Show the first name, last name, and phone number for all female faculty members.
create table Activity (
  actid INTEGER PRIMARY KEY,
  activity_name varchar(25)
);
create table Participates_in (
  stuid INTEGER,
  actid INTEGER,
  FOREIGN KEY(stuid) REFERENCES Student(StuID),
  FOREIGN KEY(actid) REFERENCES Activity(actid)
);
create table Faculty_Participates_in (
  FacID INTEGER,
  actid INTEGER,
  FOREIGN KEY(FacID) REFERENCES Faculty(FacID),
  FOREIGN KEY(actid) REFERENCES Activity(actid)
);
create table Student (
        StuID        INTEGER PRIMARY KEY,
        LName        VARCHAR(12),
        Fname        VARCHAR(12),
        Age      INTEGER,
        Sex      VARCHAR(1),
        Major        INTEGER,
        Advisor      INTEGER,
        city_code    VARCHAR(3)
 );
create table Faculty (
       FacID 	       INTEGER PRIMARY KEY,
       Lname		VARCHAR(15),
       Fname		VARCHAR(15),
       Rank		VARCHAR(15),
       Sex		VARCHAR(1),
       Phone		INTEGER,
       Room		VARCHAR(5),
       Building		VARCHAR(13)
);
INSERT into Faculty  values ( 1082, 'Giuliano', 'Mark', 'Instructor', 'M', 2424, '224', 'NEB');
INSERT into Student values ( 1001, 'Smith', 'Linda', 18, 'F', 600, 1121,'BAL');
INSERT into Activity values ( 770  ,   'Mountain Climbing'  ) ;
INSERT into Participates_in values (1001  ,  770) ;
INSERT into Faculty_Participates_in values ( 1082, 784) ;
INSERT INTO Activity VALUES [(770, 'Mountain Climbing'), (771, 'Canoeing')]
INSERT INTO Participates_in VALUES [(1001, 770), (1001, 771)]
INSERT INTO Faculty_Participates_in VALUES [(1082, 784), (1082, 785)]
INSERT INTO Student VALUES [(1001, 'Smith', 'Linda', 18, 'F', 600, 1121, 'BAL'), (1002, 'Kim', 'Tracy', 19, 'F', 600, 7712, 'HKG')]
INSERT INTO Faculty VALUES [(1082, 'Giuliano', 'Mark', 'Instructor', 'M', 2424, '224', 'NEB'), (1121, 'Goodrich', 'Michael', 'Professor', 'M', 3593, '219', 'NEB')]