Chapter 1, Problem 3EYW

Download return data for your choice of stock from Yahoo Finance - closing prices from 20 September 1991. Add the stock to the capm file. Adapt the R code available in the folder to your stock and replicate the analysis.

Alert dont submit AI generated answer. Now you want to focus on the summarizing data for Account Reps hired before 11/2018. Specifically, you want to calculate the total number of Account Reps. In cell J13, insert the COUNTIFS function to calculate the number of Account Reps (cell H9) in the Title column where the date in the Hire Date column was before 1/1/2018. Use relative references for the two criteria range arguments and the title criteria argument in cell H9. Type the date comparison for the second criteria argument. The next step is to calculate the total salary for Account Reps hired before 11/2018. You will use mixed references so that you can later copy the function and change the function name for other calculations. In cell H14, insert the SUMIFS function to calculate the total amount in the Salary column where the Title contains the job title criteria Account Rep (cell H9) and where the date in the Hire Date column was before 1/1/2018. Use relative references for the…

Create a stored procedure named sp_InsertAthleteDetails, which enters details into the Athletics table by using 4 parameters for the first four columns in the Athletics table. Set No Count on.

7-Display last name of employees whose manager is KING.8-Display last name, salary and job title of all employees who earns more than the lowest salary. (Employees andJobs)9-Display all employees including King, who has no manager. Order the results by the employee number.10-Display the name and hire date of any employee hired after employee Davis

For Film_ID 1, Rename the Title of the Film to INF 506 (if this gives an error, disregard it) For Film_ID 2, Change the Rating to R For Film_ID 3, Change the Rental_Rate to 1.00 For Film_ID 4, set the Original_Language_ID to 2 For Film_ID 10, delete all text in the special features. Submission: For each of the 5 previous changes, submit a query that returns only the Film_ID and the column that was modified in each step. This should be submitted as 5 individual queries and 5 individual results.

Please give me correct solution with explanation. The DATE option of the COLUMN command does not allow a specific format to be applied to date values. True False

CREATE TABLE consumer (    ConsumerID INT PRIMARY KEY,    FirstName VARCHAR(50),    LastName VARCHAR(50),    Age INT,    Gender VARCHAR(10),    OnlineInStore VARCHAR(20)); INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online'); CREATE TABLE InStoreRetailer (    RetailerID INT PRIMARY KEY,    RetailerName VARCHAR(50),    StoreLayout VARCHAR(50),    CustomerService…

I need help doing task two: formatting the full date column to datetime format?