Construct a nested sql statement

Assignment Help Other Subject

Reference no: EM133819462

LAB EXERCISE

Instruction:
In this lab exercise, you are required to continue working with the EliteVideo database introduced in Weeks 6-9.

In this lab exercise, you must provide solutions for 5 tasks listed below. Your submission should be in an MS Word document and include the following:

A cover page
Solutions for each of the 5 tasks. Each solution must include three parts:
SQL Statement: The query written in plain text.

Explanation: A brief explanation of how the SQL statement works (approximately 150 words).

Screenshot of Results: A screenshot showing the result of running the SQL statement on your computer.

Task 1: Construct a SQL statement that retrieves the titles of movies that have not been rented yet.

Task 2: Construct a SQL statement that displays the member ID and name of the members who have rented at least one movie released in the same year they started their membership. Get it solved now!

Task 3: Construct a nested SQL statement using the NOT EXISTS function to display the names and addresses of members who have not rented any movies.

Task 4: Construct a nested SQL statement using the EXISTS function to display members (memberID, name, address) who have rented movies from a specific genre ‘Action'.

Task 5: Construct a nested SQL statement using the EXISTS function to display members (memberID, name, email) who have rented movies released in the last 6 months in 2024.

Reference no: EM133819462

Questions Cloud

Describe the overall attractiveness of the industry : BUS 225- Describe the overall attractiveness of the industry. Identify the factors that have allowed competitors to be successful in this industry thus far.

What type of patient would have hyperkalemia : What type of patient would have hyperkalemia? You are to make a clinical scenario, regarding your topic and what was done in the ER to try resuscitate them?

What did we not cover that i expected we should : What did I previously think was true, but now know to be wrong? What did we not cover that I expected we should? What was new or surprising to me?

Do the benefits of globalization exceed its costs : Does globalization promote international understanding and tolerance, or does it threaten local cultures? Do the benefits of globalization exceed its costs?

Construct a nested sql statement : Construct a SQL statement that displays the member ID and name of the members who have rented at least one movie released in the same year

What are possible flaw in paradox that complicate evaluation : Why is the paradox? How does it complicate the evaluation of happiness in modern societies? What are possible flaws in the paradox that complicate evaluation?

Develop a comprehensive research proposal : Assessment - Discuss the expected findings and their potential significance. Reflect on the study's contributions to the field, its limitations

What strategy would you follow : Assuming you want to support the pursuit of these SDGs, what strategy would you follow? Determine SMART goal and approach to achieving it that is unique to you.

Describe the major points of the article : Describe the major points of the article, and the reaction should demonstrate your interpretation of the article and how you can apply that knowledge.

User Account

All Pages