Using SQL - Microsoft SQL Server Management Studio (SSMS)

design a data warehouse table for a data scientist whose work is keeping track of job applicants resume that optimizes for the specific queries: Which candidates have a PhD in Computer Science? Which candidates have > 10 years of experience working professionally? Which candidates had a gap of greater than a year in their experience?

Then, design a table that optimizes for that query. Must include:

• A "create table" statement for your denormalized table.
• An ETL statement that extracts all data
• You should exclude records that have not been "finalized"
• Have to show field names and data types