Question 9 What are the types of the y, z and w? int x = 3; auto y = x; auto&& z = x; auto&& w = 9;

pythin in file and list , I want to make list of month from Jan to Dec , and enter sales for each month . Make average , total , minimum and max sales .

1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.

Give names of manufacturers and their cities that are located in cities with names ending with 'City'. Give all the data for sales from January 21 of 2015 through the end of the month. (Use BETWEEN) List the information of each sale item where 2 or more items were sold but only for sizes 5, 6, and 7 (Use the keyword IN.) Show all sale item information. Give date and the sum of tax and shipping for each sale from December 20th through December 25th of 2015. (use BETWEEN. Name the calculated column SUM) Create an alphabetical list of names (first and last, alphabetized by last) of customers in Minnesota. What is the customerID for Sam Gill? What are the sales dates and shipping amount of sales with over $55 of shipping charges? List the data in the Salaried Employees table about Salaried Employees earning between $40000 and $50000. (use between) Give full names of customers that have a 'D' as the third character in their last names. Eliminate duplicates. Give names of manufacturers…

Question 18 What Excel function is used to generate a random number between 0 and 1? =RAND() =RANDGEN() =RANNUM() =NUMGEN() * Previous Next Not saved Submi

You may use the Boolean operator to search for data on two separate topics at once. To get the most relevant results, Kevin should utilize which of the following Boolean operators?