Using sakila database, answer the following questions with sql queries and/or subqueries:

1. display the title of the film with the largest number of actors.
2. using "having" to display which customer’s first names have appeared more than once?
3. query the top 5 customer’s names who spent the most on rental films. display customer id, name and the amount spent.
4. what’s the result of this query? and why? select * from film natural join inventory;
5. write an interesting query statement of your own, not shown in the questions. the query should include at least one natural join operator, having clause and aggregation operation. explain your query statement and the answer.

That display data that change over time

Answerspaghetti

(1)correct answer is d.the others are just bad syntax.by using the keyword "new" and int[] together, you create a new integer array object in memory. whenever you want to create an object without using array literals, you must use new. (by array literals, i mean a line of declaration code like int[] x = {4,6}; where you literally specify an array without using new. an array literal can only be used in the same line as declaring the array.)(2)correct answer is c. it is the only choice that returns an array and properly takes in an array reference as an argument.choices a and b do not return an array; they respectively return void (nothing at all) and a primitive double, which is not a double array.choice d has invalid syntax. looking at it, it won't properly accept any array reference you pass into the method.(3)correct answer is a.x is already defined.choice b only returns an index of the array.also, in any other method, you wouldn't write the type next to the thing being returned. choices c and d are invalid.(4)correct answer is c.choice a only accepts one.choice b requires at least two numbers.choice d only takes in an integer array reference, not integers.(5) correct choice is d.by specifying that the first argument can take in any number of ints, java will assume everything you input into the method will be an integer.theoretically it will never reach that string argument, no matter how many commas you put. this is illegal; the java compiler will complain. i don't think it'll even recognize it as a method header.

You should learn as many programming lanauges as you can or be a skid and copy and paste! you should have an iq above 110. you should also try to study some operating systems both new and old to get an understanding of what they are. you should definitely learn java because it is very important to know in this line of work unless you want work as a professional skid. i would also get my c.i.s.s.p. and c.e.h. and a degree in computer science.