Skip to content

Practice queries for the film table in the Sakila sample database using MySQL

Notifications You must be signed in to change notification settings

er-hiba/MySQL-sakila-film-practice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Description

This repository contains SQL queries for practicing the LIKE operator with the film table in the Sakila database. The queries demonstrate how to search for films based on specific patterns in their titles and descriptions.

Queries Summary

  1. Films whose title begins with 'dr'
  2. Films whose title ends with 'tion'
  3. Drama films
  4. Films whose title starts with 'c' and ends with 'tion'
  5. Films whose title begins with a word of 3 letters
  6. Films whose title begins with 'on' after the first character

About

Practice queries for the film table in the Sakila sample database using MySQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published