Run an SQL query to determine the number of salespeople working at ZoomZoom on 2018-01-01. Exclude any salespeople that were terminated before 2018-01-01 and exclude salespeople that were hired after 2017-12-31. Provide the text of your SQL query and the number of salespeople working at ZoomZoom on 2018-01-01. BUS-235E Data Visualization and Management Assignment #2 2024 Michael G. Klein 2 San Jos State University c. Run an SQL query to determine the number of salespeople working at ZoomZoom on 2019-01-01. Exclude any salespeople that were terminated before 2019-01-01 and exclude salespeople that were hired after 2018-12-31. Provide the text of your SQL query and the number of salespeople working at ZoomZoom on 2019-01-01. d. Run an SQL query using DATE_TRUNC to determine the number of new salespeople hired by month at ZoomZoom in the year 2018. Provide the text of your SQL query and a table of the results with columns for the hiring month and the number of new hires. e. Is the number of new hires from part d the same as the difference between the number of salespeople working at ZoomZoom on 2018-01-01 (from part c) and the number of salespeople working at ZoomZoom on 2017-01-01