SQL


SQL: Multiple Tables Learn how to query multiple tables using joins.
Analyzing: Common Metrics You can use this category to discuss the SQL: Analyzing Business Metrics - Common Metrics exercises.
SQL: Manipulation Get up and running with SQL by learning commands to manipulate data stored in relational databases.
Table Transformation: Conditional Aggregates You can use this category to discuss the SQL: Table Transformation - Conditional Aggregates exercises.
Create Table In this project you will create your own friends table and add and delete data from it.
Fake Apps In this project you will write queries with aggregate functions to retrieve information from the fake_apps table.
Writing Queries In this project you will write queries to retrieve information from the movies table.
Querying Tables In this project you will practice querying multiple tables using joins.
SQL: Aggregate Functions Learn how to use SQL to perform calculations during a query.
Analyzing: Advanced Aggregates You can use this category to discuss the SQL: Analyzing Business Metrics - Advanced Aggregates exercises.
Table Transformation: Date, Number & String You can use this category to discuss the SQL: Table Transformation - Date, Number and String Functions exercises.
Table Transformation: Set Operations You can use this category to discuss the SQL: Table Transformation - Set Operations exercises.
SQL: Queries Learn the most commonly used SQL commands to query a table in a database.
Table Transformation: Subqueries You can use this category to discuss the SQL: Table Transformation - Subqueries exercises.

About the Learn SQL category [SQL] (2)
Having question 9 fake apps [Fake Apps] (3)
4/7 Subqueries [Table Transformation: Subqueries] (2)
Daily Revenue 2: Incorrect Solution [Analyzing: Common Metrics] (2)
Lesson 9 HAVING -- Why did HAVING COUNT(price) and HAVING COUNT(downloads) both work? [Analyzing: Advanced Aggregates] (5)
SQL, using "AND" [Querying Tables] (4)
Excercize shows incorrect schema [SQL: Multiple Tables] (4)
Step 4! [Create Table] (5)
1 day retention syntax question [Analyzing: Common Metrics] (3)
Insufficient information to answer a question [SQL: Manipulation] (13)
Daily Revenue 2 [Analyzing: Common Metrics] (4)
Preventing SQL Injection [Fake Apps] (5)
SQL manipulation Primary Key vs Foreign Key [Create Table] (2)
Redo Lessons - Learn SQL [SQL] (3)
No such table: orders [SQL: Manipulation] (4)
SQL Queries Exercise #4 "Where" [SQL: Queries] (2)
Combining Tables with SQL [SQL: Multiple Tables] (4)
Sqlite (WITH statements) [SQL: Manipulation] (2)
SQL: Table Transformation (2/7) [Table Transformation: Subqueries] (2)
How do Inner Joins 4/10 [Create Table] (2)
What's the difference between single quote and double quote in sql query [SQL: Queries] (3)
Issues with lesson showing wrong date - Would love some help [Table Transformation: Date, Number & String] (3)
Am I misunderstanding the objective tasks? [Create Table] (13)
Date Format [Create Table] (12)
Create table, 2nd step [Create Table] (11)
SQL Manipulation 2 - Answer not correct...? [SQL: Manipulation] (5)
4/8 count(case when...) [Table Transformation: Conditional Aggregates] (4)
Date III So this works in SQLite but does it work with....? [Table Transformation: Date, Number & String] (2)
Queries "Case" [Writing Queries] (3)
Practice #13 Return the total number of apps for the business category [Fake Apps] (5)