TIL

TIL

  • Docs
  • Contact
  • Feedback
  • Contribute

›Week 10

Getting Started

  • Introduction

Principles of Programming Languages

    Week 3

    • Pattern Matching and Recursive Data Types

    Week 8

    • Monads

Introduction to Databases

    Week 3

    • Cinema Database

    Week 4

    • Pine Valley Furniture
    • Pine Valley Furniture - Solution

    Week 5

    • ERD to Shorthand Conversions
    • ERD to Shorthand Conversions - Solution

    Week 6

    • Normalizations
    • Normalizations - Solutions

    Week 7

    • Other Normal Forms
    • Other Normal Forms - Solutions

    Week 8

    • SQL Introduction

    Week 9

    • More SQL

    Week 10

    • Joins and Subqueries

    Week 11

    • Functions, Procedures, Triggers and Embedded SQL

    Week 12

    • Prepared SQL Statements
Edit

Joins and Subqueries

Introduction

We will be working with the Sakila database provided by the MySQL community. The relevant tables you will need to answer the following questions are given in this schema diagram:

Schema

Questions

  1. Find the name of all comedies
  2. List the names of all sci-fi films using two approaches
  3. List all films that cast PENELOPE GUINESS using two approaches
  4. Using a subquery, find the names of all actors/actresses who cast in ANGELS LIFE
  5. Write query 4 without any subquery
  6. Find the names of the films that either had the most or the least rental duration
  7. Find the name of the most popular category
Last updated on 1/4/2019
← More SQLFunctions, Procedures, Triggers and Embedded SQL →
  • Introduction
  • Questions
TIL
Docs
Getting StartedPrinciples of Programming Languages (C24)Introduction to Databases (C43)
Community
PiazzaQuercus
More
GitHubStar
Facebook Open Source
Copyright © 2019 Rakin Uddin