FIRST	LAST	Co.	SEX	AGE	Dr. Visit	Insurance	Deductible
Linda	Alvarez	Gulliver	F	32	October 2	Aetna	200.00
Edward	Stone	Rockway	M	40	September 4	Broderbund	45.00
Lucille	Guttierez	Gulliver	F	28	October 10	Prudential	100.00
Christina	Lopez	Gulliver	F	52	June 1	John Hancock	51.00
John	Smith	Southern	M	47	May 21	Aetna	112.00
Sergio	Martinez	Gulliver	M	18	October 21	Aetna	142.00
Jill	Palanka	Aero Sur	F	22	March 2	John Hancock	254.00
Alex	Anthony	Flynn	M	28	June 12	Brandeis	30.00

 

Insert the above “Claims” table in a new database called “Pending Insurance Info”

 

·        Create a query that will show only the last and first names of clients.

 

·        Create a query that will show all fields for clients whose company is Gulliver.

 

·        Create a query that will show all fields for clients whose age is less than 50. Print out the results of this query to hand in.

 

·        Create a query that will show all fields for clients whose insurance company starts with the letter B.

 

·        Create a query that will show all fields for deductibles of less than $50.00.

 

·        Create a query that will show all fields for clients who are male and whose age is greater than 50.

 

·        Create a query that will show all fields for clients whose company is Aetna. or whose insurance is John Hancock. Print out the results of this query to hand in.

 

·        Create a query that will show all fields for clients whose ages are between 30 and 40, inclusive.

 

·        Create a query that will show all fields for clients whose ages are strictly greater than 45 . Print out the results of this query to hand in.

 

·        Create a query that shows all of the records of the client table and sort them by age and sex.

 

·        Create a query that will show just the last and first name fields of a client, the office visit date, and the deductible the patient must pay. Print out the results of this query to hand in.