Query User Levels With Left Join

Beginner

In this project, you will learn how to query user levels from a database using a left outer join. This project is designed to help you understand the concept of left outer joins and how to apply them to real-world data scenarios.

SQLMySQL

Introduction

In this challenge, we'll use a MySQL database to create tables and insert data. Our primary goal is to retrieve the level information of all users by querying data using a left outer join.

This is a Challenge, which differs from a Guided Lab in that you need to try to complete the challenge task independently, rather than following the steps of a lab to learn. Challenges are usually a bit difficult. If you find it difficult, you can discuss with Labby or check the solution.

Teacher

Labby

Labby is the LabEx teacher.