Practice Common Table Expressions (CTES): SQL 30 Day Challenge Day 20
Vložit
- čas přidán 22. 08. 2024
- Practice using common table expressions (CTEs) in SQL using the www.sql-practice.com online editor. After practicing CTEs try to get the same results using sql joins or sql subqueries.
Questions:
Select ALL Product Names & their Category Names
Select CustomerID and Each Customers Number or Orders.
Select the ProductName and the TOTAL Number of Orders for Each Product (only return products that have been ordered more than 50 times)
-----------------------------------------------------------------
Here is the SQL website to practice your queries: www.sql-practi...
Download SQLite Studio Here: sqlitestudio.pl/
Download the Chinook Database: www.sqlitetuto...
Link to Topic List: docs.google.co...
Link to Facebook Support Group: / 767988395118964
Link to my Data Etsy Shop (support me to keep making content): jellysgeekygoo...
Buy me a coffee to show support: buymeacoffee.c...