Delete Course Schedule View Data

# Introduction

In this project, you will learn how to create a view based on the `teaches` table and delete the related data from the view.

## 👀 Preview

MySQL [edusys]> SELECT * FROM teaches_view;
+-------+----------+----------+------+
| id    | courseId | semester | year |
+-------+----------+----------+------+
| 76766 | BIO-101  | Summer   | 2017 |
| 10101 | CS-101   | Fall     | 2017 |
| 83821 | CS-190   | Spring   | 2017 |
| 83821 | CS-190   | Spring   | 2017 |
| 10101 | CS-347   | Fall     | 2017 |
| 98345 | EE-181   | Spring   | 2017 |
| 22222 | PHY-101  | Fall     | 2017 |
+-------+----------+----------+------+
7 rows in set (0.000 sec)

## 🎯 Tasks

In this project, you will learn:

- How to create a view with specific fields from the `teaches` table
- How to delete data from the created view based on a certain condition

## 🏆 Achievements

After completing this project, you will be able to:

- Understand the concept of a view and how to create one
- Manipulate data in a view by deleting records that match a specific condition
- Apply these skills to manage data in a database more efficiently