# Introduction In this project, you will learn how to create a database, a table, and insert data into the table. You will also learn how to perform a self-join query on the data to find the province to which a city belongs. ## ð Preview ![Unfinished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/mysql/project-city-province-query/lab-city-province-query/assets/img_1.png) ## ðŊ Tasks In this project, you will learn: - How to start the MySQL service and access MySQL using the `sudo` command without any password. - How to create a database, a table, and insert data into the table. - How to write a self-join query on the `division` table to find the province for each city. - How to run the self-join query script in MySQL. ## ð Achievements After completing this project, you will be able to: - Understand the basic operations of creating a database, a table, and inserting data in MySQL. - Perform self-join queries to retrieve related information from a table. - Apply your knowledge of SQL queries to solve real-world problems.
Click the virtual machine below to start practicing