Question 1. write a SQL statement to display the flight numbers (FLT_NUM) and flight dates (FLT_DATE) of all the flights on the ASSIGNMENT table whose flight number (AC_NUM) ends with a "G". 2. write a SQL statement to update the aircraft number (AC_NUM) of the flight number (FLT_NUM) equal to 101 and flight date (FLT_DATE) equal to 15 January 2016, to 411H. 3. write a SQL statement to add a new record to table FLIGHT. Make use of prompts to allow tge values for all the fields of the table to be entered. 4. write a SQL statement to give a summary of the total number of flights per aircraft number (AC_NUM) on table ASSIGNMENT. display the total number of flights with a heading "Total Number of Flights". 5. write a SQL statement that lists all flight dates (FLT_DATE), flight origins (FLT_ORIGIN) and flight destinations (FLT_DESTINATION). Sort the list according to descending flight date and ascending flight origin. Database name: Ch02_Airline Table name: AIRCRAFT Table name: ASSIGNMENT AC_NUM 123U 375G 411H AC_MODEL MD-80 B-737 B-737 FLT_NUM FLT_DATE AC_NUM 101 14-Jan-16 375G 101 15-Jan-16 375G 101 16-Jan-16 411H 101 17-Jan-16 375G 101 18-Jan-16 1230 102 14-Jan-16 375G 102 15-Jan-16 375G 102 16-Jan-16 411H 102 17-Jan-16 375G 102 18-Jan-16 1230 Table name: FLIGHT FLT_NUM FLT_ORIGIN FLT_DESTINATION 101 MEM ATL 102 ATL MEM

1. What is the result of the following Python expression?print(((3 + 5) // 2 * 2 **3) % 7 2. Write the the code to print the result of the following expression: multiply 1234567890 by 987654321, then add 67890 3. Write a program that calculates the remainder of 10 divided by 3 and prints the result 4. Extracting the square root of a number is equivalent to raising this number to a certain power. What power are we talking about? (the answer is a number)

What evidence supports the conclusion that the SLC24A5 gene contributes to the production of melanin in humans in the same way it does in fish? Select all that apply. Hint: Review the section of the paper entitled “Conservation of golden gene structure and function in vertebrate evolution.” A)Injection of golden zebrafish larva with human SLC24A5 messenger RNA (mRNA) restores the fish’s ability to make melanin. B.)The slc24a5 protein produced by the gene in the zebrafish is 68 – 69% similar to the SLC24A5 protein in humans. C)At least 93% of East Asians share the same G allele of the SLC24A5 gene with Africans, yet East Asians are usually light skinned. D)The zebrafish slc24a5 gene and the human SLC24A5 gene are both expressed at high levels in skin and eyes.

(1 point) Determine the average rate of change of the following function between the given values of the variable: f(x) = x4 - - X; x = -2, x = 3 Average rate of change = .

Question Suppose three point masses are placed in the xy-plane as follows (assume coordinates are given in meters): mi = 5 kg, placed at (-2, -3) m2 = 3 kg, placed at (2,3) 'm3 = 2 kg, placed at (-3, -2) Find the center of mass of the system. Write your answer as an ordered pair Provide your answer below:

let f(x)= x^2-5, g(x)= 2x^3+x and p(x)= f(x)g(x). a) computedp/dx b) compute f'(x)g'(x)

Suppose that a company is developing a new touch-screen cell phone. Historically, 70% of their new phones have resulted in high consumer demand, whereas 30% have resulted in low consumer demand. The company has the decision of choosing between two models with different features that require different amount of investment and have different sales potential. Estimated profit/loss are shown in the payoff table below. State of Nature High demand, ($) Low demand, ($) Model 1 300,000 -40,000 Model 2 275,000 -15000 Now suppose the firm conducts a market research study to obtain sample information and better understand the nature of consumer demand. The market research cost $10,000 Analysis of past market research studies, conducted prior to introducing similar products, has found that the survey response will be either high or low. There is a 69% chance that the survey will return a high survey response (results) and there is a 31% chance that the survey will result in lo-demand response (results). The relevant conditional probabilities are as follows: P (high consumer demand, high survey response = 0.913) P (low consumer demand, low survey response = 0.087) P (high consumer demand, high survey response = 0.226) P (low consumer demand, low survey response = 0.774) Calculate the expected value of sample information (EVSI). Develop a decision tree and analyze using QM for Windows. Determine the optimal solution.