Modify customer 1000 to indicate the date of birth on March 15, 1989. Use YYYY-MM-DD format for inserting dates.

8. Use the Form Wizard to create a new form for inputting sales data. Include all the fields from the PopcornSales table. a. b. Include the Item and Quantity fields from the SaleDetails table. c. View the form data by records in the PopcornSales table with related records in the SaleDetails table displayed in a subform. d. The subform should be displayed as a Datasheet. e. Name the main form: PopcornSales Form and name the subform: SaleDetailsSubform (Hint: Be sure to remove the space between ure.com/courses/79665/assignments/1378308?module_item_id=3226669 f. g. Access 365/2021 Capstone - SIMnet SaleDetails and Subform in the subform name suggested by Access.) Open the form in Form view to review your work. Navigate to the record in the main form for SaleID 3 and enter sale details in the subform as follows: Item: Truffle, Quantity: 3 Item: Old Bay, Quantity: 2 h. Close the form.

This kind of code gives me errors i have more info below. My codeDELIMITER //CREATE PROCEDURE GET_INVOICE_DATE  (in I_INVOICE_NUM CHAR(5))DECLARE I_CUST_ID CHAR(5),DECLARE I_CUST_NAME VARCHAR(41),DECLARE I_INVOICE_DATE DATE BEGIN SELECT c.CUST_ID, CONCAT(c.FIRST_NAME, ' ', c.LAST_NAME), i.INVOICE_DATE INTO I_CUST_ID, I_CUST_NAME, I_INVOICE_DATE FROM INVOICES i INNER JOIN CUSTOMER c ON i.CUST_ID = c.CUST_ID WHERE i.INVOICE_NUM = I_INVOICE_NUM; END // Delimiter ;    Helpfull info Task #6 – same process as Task #5• Procedure name is GET_INVOICE_DATE with I_INVOICE_NUM in parentheses with 5 characters• There should be 3 declare statements for I_CUST_ID CHAR(5); I_CUST_NAME VARCHAR(41); andI_INVOICE_DATE DATE is datatype• SELECT statement should include the CUSTOMER.CUST_ID, CONCAT for first_name andlast_name AS customer_name, invoice_date• INTO the 3 “I” fields in the declare statement• From should include the CUSTOMER and INVOICES tables• Where clause to join CUSTOMER.CUST_ID =…

calculate_trip_time( iata_src: str, iata_dst: str, flight_walk: List[str], flights: Flight Dir float: def ) -> """ Return a float corresponding to the amount of time required to travel from the source airport to the destination airport to the destination airport, as outlined by the flight_walk. The start time of the trip should be considered zero. In other words, assuming we start the trip at 12:00am, this function should return the time it takes for the trip to finish, including all the waiting times before, and between the flights. If there is no path available, return -1.0 >>> calculate_trip_time("AA1", "AA2", ["AA1", "AA2"], TEST_FLIGHTS_DIR_FOUR_ 2.0 "AA7", ["AA7", "AA1"], TEST_FLIGHTS_DIR_FOUR_ "AA7", ["AA1", "AA7"], TEST_FLIGHTS_DIR_FOUR_ "AA1", ["AA1"], TEST_FLIGHTS_DIR_FOUR_CITIES) "AA2", ["AA4", "AA1", "AA2"], TEST_FLIGHTS_DI "AA3", ["AA1", "AA2", "AA3"], TEST_FLIGHTS_DI >>> calculate_trip_time("AA1", "AA4", ["AA1", "AA4"], TEST_FLIGHTS_DIR_FOUR_ 2.0 || || || >>>…

Use "Sort" when you need to order data in ascending or descending order.Select one:a. False b. True

8. Using the Min function, write a formula in cell F10 of Top10_Pivot Sheet to find the minimum "Sum of Percentage" value. Do not select the Grand Total range in the function. Screenshots attached thanks

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

Output the information in a formatted table. The title is right justified with a width of 33. Column 1 has a width of 20. Column 2 has a width of 23. Ex: Number of Novels Authored Author name | Number of novels -------------------------------------------- Jane Austen | 6 Charles Dickens | 20 Ernest Hemingway | 9 Jack Kerouac | 22 F. Scott Fitzgerald | 8 Mary Shelley | 7 Charlotte Bronte | 5 Mark Twain | 11 Agatha Christie | 73 Ian Flemming | 14 J.K. Rowling | 14 Stephen King | 54 Oscar Wilde | 1

Use Python Code Your task is : Number of reported COVID-19 deaths by country. (Use pandas to read the csv table. Example : df = pd.read_csv('Covid19Deaths.csv') then do the code using the dataframe) COVID-19 Deaths table (csv): Province/State Country/Region Lat Long ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 2/1/2020 2/2/2020 2/3/2020 2/4/2020 2/5/2020 2/6/2020 2/7/2020 2/8/2020 2/9/2020 ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 3/1/2020 3/2/2020 3/3/2020 3/4/2020 3/5/2020 3/6/2020 3/7/2020 3/8/2020 3/9/2020 ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 4/1/2020 4/2/2020 4/3/2020 4/4/2020 4/5/2020 4/6/2020 4/7/2020   Afghanistan 33 65 0 0 0 0 0 0 0 0…

Answer in R code please