Using Structured Query Language (in Microsoft SQL Server):

1. Write the code that will create a table called tblPeople that will match and store the data from People.txt (inserted below)
2. Write the code that will import all the records from the file into tblPeople
3. Write a query that returns all people with the first name of: Dale
4. Write a query that returns the first name, last name, and email of all females

People.txt :

id first_name last_name email gender ip_address

1. Cherilyn Camden ccamden0@huffingtonpost.com Male184.129.31.27

2. Dunstan Brimham dbrimham1@google.ca Female51.55.148.74

3. Adair Winslett awinslett2@cnet.com Agender 158.4.53.87

4. Karmen Lergan klergan3@theguardian.com Bigender9.106.252.115

5. Hazel Lindro hlindro4@digg.comBigender 172.145.147.40

6. Lidia Hellings lhellings5@techcrunch.com Non-binary176.96.79.214

7. Artemus Cheverell acheverell6@noaa.gov Agender 65.196.2.93

8. Jewelle Carss jcarss7@bloglines.com Male 177.60.30.139

9. Starlin Barkus sbarkus8@cdc.gov Bigender 124.131.108.38

10. Dale Burgill dburgilla8@geocities.com Male 28.149.192.110

Example Starter Code:

USE Example; DROP TABLE IF EXISTS [tblPeople] -- Q1 (5 pts): Create tblPeople table -- Q2 (5 pts): Import your records from the file -- Q3 (5 pts): Query that returns all fields from tblPeople that have a first name of Dale -- Q4 (5 pts): Query that returns the first name, last name, and email of all females