Reference no: EM1347283
Q1) Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."
SELECT STARNAME,MVTITLE, MVYEAR, (COUNT)BESTM AS BEST_MALE
FROM STAR, MOVSTAR, MOVIE
WHERE STAR.STARNUM = MOVSTAR.STARNUM AND
MOVIE.MVNUM = MOVSTAR.MVNUM AND
BESTM="W" AND SEX="M"
GROUP BY STAR.STARNAME
HAVING (COUNT)BESTM>2
ORDER BY STARNAME
Q2) List all movies that have won all the awards they were nominated for (nominations = awards), and who have more than one nomination. Give the movie title, year, the number of nominations and the number of awards won. Order by the nominations (descending)."SELECT MVTITLE, MVYEAR, CATID, SUM(NOMS) AS NOM, SUM(AWRDS) AS AWRD
FROM MOVIE, STAR, MOVSTAR
WHERE MOVIE.MVNUM=MOVSTAR.MVNUM AND STAR.STARNUM=MOVSTAR.STARNUM AND
CATEGORY.MVNUM=MOVIE.MVNUM
HAVING COUNT(NOMS) >1
ORDER BY, NOM DESC;
|
Examine companys fundamentals of financial management
: Valuation of securities - How does in fit in a portfolio and Examine the company's Fundamentals of Financial Management
|
|
Cost-volume-profit analysis and strategy
: Mr. Carter is manager of Simmons Farm and Seed Company, a wholesaler of fertilizer, seed, and other farm supplies. The company has been successful in current years primarily because of great customer service, flexible credit terms, customized orde..
|
|
Elucidate why these companies oppose laws allowing
: Elucidate why these companies oppose laws allowing reimportation of drugs to the United States.
|
|
What force required to pull the same wooden
: The small piston of a hydraulic lift has a cross-sectional area of 3 cm2, and its large piston has a cross-sectional area of 200 cm2. What force should be applied to the small piston for the lift to raise a load of 15kN
|
|
Write down name of actors in ascending order
: Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."
|
|
Describe theory of motivation
: Show the list at least one reason why you think workers may be more motivated by job security rather than benefits and salary in difficult economic times.
|
|
Illustrate what role does macroeconomics play
: Illustrate what role does Macroeconomics play in your personal financial decisions and that of your place of work or firm you are familiar with.
|
|
Cost volume profit analyses
: After reviewing its cost structure (variable costs of £7.50 per unit and monthly fixed costs of £60,000) and its potential market, the Forecast Company established what it considered to be a reasonable selling price.
|
|
Determine the expected return for individual stock
: Jane is planning investing in 3 different stocks or developing three distinct 2 stock portfolios. Jane considers herself to be a rather conservative investor. Determine the expected return for each individual stock.
|