SQLGate

SQLGate Blog - The Most Intelligent IDE for Databases

[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery

[SQL Basic] Let’s find customers that have rented movies priced $9.99! — SQL Subquery

#15. Marketing/Data Analysis for Beginners #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson 4 [https://blog.sqlgate.com/sql-basic-how-to-sort-film-lists-by-price-rental-rate-using-the-sql-query-order-by/] : ORDER BY 📌Lesson 5 [https://blog.sqlgate.com/sql-basic-can-i-rent-a-3-hour-movie-thats-only-0-99-using-sql-and-or-in/] : AND / OR / IN 📌Lesson 6 [https://blog.sqlgate.com/sq
7 min read
[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN

[SQL Basic] Let’s check movie rentals by the inventory list! — SQL LEFT / RIGHT JOIN

#14. Marketing/Data Analysis for Beginners #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson 4 [https://blog.sqlgate.com/sql-basic-how-to-sort-film-lists-by-price-rental-rate-using-the-sql-query-order-by/] : ORDER BY 📌Lesson 5 [https://blog.sqlgate.com/sql-basic-can-i-rent-a-3-hour-movie-thats-only-0-99-using-sql-and-or-in/] : AND / OR / IN 📌Lesson 6 [https://blog.sqlgate.com/sq
7 min read
[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN

[SQL Basic] Let’s find out the movie genres by joining tables! — SQL INNER JOIN

#13. Marketing/Data Analysis for Beginners #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson 4 [https://blog.sqlgate.com/sql-basic-how-to-sort-film-lists-by-price-rental-rate-using-the-sql-query-order-by/] : ORDER BY 📌Lesson 5 [https://blog.sqlgate.com/sql-basic-can-i-rent-a-3-hour-movie-thats-only-0-99-using-sql-and-or-in/] : AND / OR / IN 📌Lesson 6 [https://blog.sqlgate.com/sq
9 min read