SQL Database Creation and Non-Equijoin Query

# Introduction In this project, you will learn how to create a database, tables, and insert data. You will then execute a non-equijoin query to retrieve the level of all users based on the information in the database. ## 👀 Preview ![Unfinished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/mysql/project-query-user-level/lab-query-user-level/assets/img_1.png) ## ðŸŽŊ Tasks In this project, you will learn: - How to access MySQL using the `sudo` command without any password - How to create the `vip` database - How to create the `level` and `user` tables and insert data into them - How to write a SQL query to retrieve the level of all users ## 🏆 Achievements After completing this project, you will be able to: - Understand the process of creating a database and tables - Gain experience in inserting data into tables - Learn how to execute a non-equijoin query to retrieve data from multiple tables - Apply your SQL knowledge to solve a real-world problem

|
60 : 00

Click the virtual machine below to start practicing