Skip to content

Latest commit

 

History

History
10 lines (9 loc) · 525 Bytes

README.md

File metadata and controls

10 lines (9 loc) · 525 Bytes
Raw

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