Question: You will need to submit the SQL and output for the following. In this assignment you will be creating and selecting data so be sure
You will need to submit the SQL and output for the
following.
In this assignment you will be creating and
selecting data so be sure you save you SQL and
results as you go
Create or modify a table to have the fields:
First Name
Last Name
Street Address
City
State
Zip
Mobile Phone
Home Phone
Date of Birth
Biologic Gender
Add or identify the table's primary key and make
sure those fields can not be empty or null.
Insert rows of people.
Select all rows
Select all females
Select all males
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
