##Instructions implement this business scenario as a T SQL script. create a table, insert the sample data, and write the queries for the reports. I have a recruiting company called Educators Connect, which specializes in helping educators find jobs, mainly right after graduating. Every day we place many educators in different schools all over New York. In order to conduct data analysis, we want to keep track of our educators and various details about them.
I need to know the first name, last name, date of birth, gender, college attended, and title of their degree. Then I need to know how they found out about recruiting company, the date they contacted us, which school we placed them in and the date we found them a job.
Reports:
- I need to know how many students from each college we were able to find jobs for in under 2 weeks. This will help my company know which college's graduates we should try to attract to our company.
- Who were we more successful in placing, males or females?
- On average, how many people contact us every day and how many people fnd out about us per form of media. This will help us decide which forms of media communication we should invest in.
- On average, how many people do we succeed in placing per day?
- How many educators get placed a day per type of education degree?
- I need a list of the educators who reach out to us in the format of first name, last name, age, - degree.
Question: Do you deal with all age brackets? Answer: yes Question: What are the forms of media you use to advertise? Answer: We post ads about our company in magazines, newspapers, and social media sites. Sometimes people hear about us by word of mouth. Question: Do you specifically help graduates who graduated from a New York College? Answer: Not specifically. We help people who graduated from any college in the United States, but are living in New York. Question: How long has your company been around? Answer: I opened up about 5 years ago, on February 17, 2017. Question: Are there any educators whom as of now, you have not succeeded in placing? Answer: Unfortunately yes. This is why I would like you to conduct reports to see the factors specific to educators we struggle to place. Question: Is there a certain degree level you mainly cater to? Answer: No. We help those with any level of education degree, whether it's a bachechelors, masters, or PhD
Sample Data: First name, last name, DOB, gender, college attended, title of degree, Media, date contacted, school placed, date found job Mary, Lynn, 9/13/2000, female, Excelsior College, BA in Mathematics Education, magazine, 5/2/2022, Brooklyn High School, 5/9/2022 Josh, Frank, 4/23/1998, male, Georgia State University, MA in Social Studies Education, social media site, 2/12/2022, Manhattan Elementary School, 5/9/2022 Charles, Smith, 7/9/1994, male, Excelsior College, PhD in Education, social media site, 8/7/2021, New York City Day School, 8/12/2021 Samantha, Brown, 9/24/1999, female, Columbia University, BA in English Education, newspaper, 5/23/2021, Brooklyn High School, 7/30/2021 Howard, Lang, 8/4/1998, male, Georgia State University, MA in History Education, word of mouth, 1/31/2022, null, null Sarah, Blanks, 10/20/1995, female, Columbia University, MA in Science Education, social media, 5/23/2020, New York City Day School, 8/17/2020 Ella, Lewis, 8/22/2000, female, Excelsior College, BA in English Education, word of mouth, 4/1/2022, null, null Julie, Goldman, 3/30/1997, University of Denver, MA in Social Studies Education, social media, 7/14/2020, Manhattan Elementary School, 8/17/2020