Reference no: EM132137144
A streaming company needs to measure the AVERAGE time spread for users who watch video on their platform in a session.
Each user has one time spread, which is the difference between her longest session streaming video and her shortest session in her individual history with the company (regardless of the users' age at the time the sessions were made).
The company is interested in users between the ages of 26 and 31, inclusive, who have at least 50 sessions stored in the DB. There are several tables in the DB, but the ones of interested here are:
User (uid__, name, age) , SessionRecord(uid__, date__, duration)
Primary key attributes are underlined. In the table definitions, the attribute of age is declared as NOT NULL, but duration can be NULL.
Write a query that satisfies the above requirements by making sure to use GROUP BY and HAVING clauses.
|
Print the converted sentence both to the screen
: Print the converted sentence both to the screen and to an output file. Your input file consists of a variable number of records.
|
|
Develop your own string class
: Develop and work with a C++ class, define constructors and destructors, define member functions outside .
|
|
Which of the following statements will display a string
: Which of the following statements will display a string as "Jones, Jane" (the last name, a comma, a space, and the first name) in the lblFullName control?
|
|
Write a method with an input variable
: Write a method with an input variable (string type). The method should return the number of uppercase letters of the input variable.
|
|
Write a query that satisfies the given requirements
: Write a query that satisfies the given requirements by making sure to use GROUP BY and HAVING clauses.
|
|
Prompts the user to input the shipping cost per liter
: Amanda and Tyler opened a business that specializes in shipping liquids, such as milk, juice, and water, in cylinderical containers.
|
|
What is the present value of a 3-year annuity
: What is the present value of a 3-year annuity of $170 if the discount rate is 5%? (Do not round intermediate calculations. Round your answer to 2 decimal places
|
|
What is the expected return on portfolio
: What is the expected return on this portfolio? What is the beta of this portfolio? Does this portfolio have more or less systematic risk than an average asset?
|
|
Give an algorithm about to define the polynomial time
: Give an algorithm that, given strings A, B, and C, decides whether C is an interleaving of A and B in polynomial time. Prove your answer correct.
|