DataBase Management Systems -

Share your solutions to the prompts for a series of SQL queries

1. Using postgresql - What will be the query that produces a list of student names and their GPAs.

2. Using postgresql - What will be the query that shows each student status (Fr, So, Ju, Se) along with the highest GPA of that student status.

3. Using postgresql - What will be the query that shows all information about the contests between the dates 06/01/2012 and 12/29/2012.

4. Using postgresql - What will be the query that shows the points awarded (the sum of the first, second and third places) in each of the contests between the dates 06/01/2012 and 12/29/2012 along with the date of the contest.

Solve the following 1st order differential equation and find the value of y (0.9) Then using a step size of h=0.3, Find the value of y(0.9) using Runge-Kutta 4th order method . Then calculate the percentage error. Use excel to solve the equation using Runge Kutta and its error. 2 V = 3x y( 1.9) = 5For the ODE dy 2 + 3xy = e-1.5x dx y(0) = 3, estimate y(4) with a step size of 2 using a. Heun's Runge-Kutta 2nd order method b. Midpoint Runge-Kutta 2"d order method c. Ralston's Runge-Kutta 20 order methodResponse Analysis Linear Regression Continuous Regression Trees Logistic Regression Categorical Decision Trees Generalized Positive, Counts Linear ModelsProblem 2: 2.1) Write down the mathematical definition of each of the following. (Be precise in your definitions. Each definition should be a mathematical statement.) (a) A random variable (b) The pdf of a random variable. (Specify whether the random variable is discrete or continuous.) (c) The pmf of a random variable. (Specify whether the random variable is discrete or continuous.) (d) The cdf of a random variable. (Specify whether there are any restrictions on whether the random variable is discrete or continuous.) (e) the expected value of a random variable. (Give separate expressions for discrete and continuous random variables.) (f) the expected value of a function of a random variable. (Give separate expressions for discrete and continuous random variables.) 2.2) Write down the mathematical definition of each of the following random variables. (Each definition should be a mathematical statement.) For any parameters of the distribution, explain the meaning of each parameter. Specify whether each of these is a discrete or continuous random variable. (a) a Bernoulli random variable (b) a Binomial random variable (c) a geometric random variable (d) a Poisson random variable (e) a uniform random variable (f) an exponential random variable (g) a normal (or Gaussian) random variable