SQL Tutorial : Analyzing Business Data in SQL

Want to learn more? Take the full course at https://learn.datacamp.com/courses/analyzing-business-data-in-sql at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- Hello! My name's Michel, and I'll be your instructor. You've finished some SQL courses on DataCamp already, so you have a firm grasp on SQL, but you probably haven't used it in a business context yet. In this course, you'll write SQL queries to analyze a company's data to uncover facts about it and improve its operations. Let's go over the course's chapters. In chapter one, this chapter, you'll calculate revenue, cost, and profit. In chapter two, you'll learn about user-centric metrics, namely registrations, active users, growth, and retention. In chapter three, you'll learn about unit economics and distributions. Finally, in chapter four, you'll generate an executive report. Let's dive in. Delivr is a fictional food delivery startup similar to Uber Eats. Delivr stocks meals from eateries in bulk, then offers users these meals through its app. It owns an electric scooter fleet it uses to deliver meals to its users. Its competitive advantage is that users can order meals from several eateries in one order. You've been hired there as a data analyst, and your first task is to determine Delivr's profitability. A company's performance is often judged by its profits. Profit is the money a company makes minus the money it spends. The former is revenue, while the latter is cost. Accordingly, the formula for profit is Profit = Revenue - Cost. Delivr's revenue is the money its users pay for the meals they order. Some of its costs include the salaries paid to its employees. For now, let's focus on revenue. Delivr stores its data in an SQL database. Let's explore the tables needed to calculate revenue. The first table is meals. Each row represents a meal that users can order through the app. Each meal has a meal ID, an eatery, a price (what the