Question

a) Create a Table called Students b) Develop a Form with the following fields FName, LName, Test1, Test2, Test3,State c)Using the Form fill the Table with the following data FName LName Test Test 2 Test 3 State Bob Smith 79 81 86 NY Thorpe 82 Griffey 100 Colon Jim 64 91 Conn Ohio Ken 95 92 85 Bartolo 88 93 Ohio Cal Ken Keltner 91 84 87 Lou Staub 76 89 42 Mich PROBLEM: Find and print the LName of the people who live in the State of "Ohio" Problem 2: Find and print the student(s) whose FNAME is "Ken"

Answer 1

Below are the sql queries:

create table Students
(FName varchar(20) not null,
LName varchar(20) not null,
Test1 int not null,
Test2 int not null,
Test3 int not null,
State varchar(20) not null);

insert into Students values ('Bob', 'Smith', 79, 81, 86, 'NY');

insert into Students values ('Jim', 'Thorpe', 82, 64, 91, 'Conn');

insert into Students values ('Ken', 'Griffey', 100, 95, 92, 'Ohio');

insert into Students values ('Bartolo', 'Colon', 85, 88, 93, 'Ohio');

insert into Students values ('Ken', 'Keltner', 91, 84, 87, 'Cal');

insert into Students values ('Lou', 'Staub', 76, 89, 42, 'Mich');

Problem 1: select LName from Students where State = 'Ohio';

Problem 2:   select FName, LName from Students where FName = 'Ken';