Question: - SQL project - TFDS course I - Use your databasel - Code here: I - -1. Create a table in your database named Gradel

- SQL project - TFDS course I - Use your databasel - Code here: I - -1. Create a table in your database named Gradel - Add variables: CourseID, Score, Semesterl - Populate the table with fake data - at least 3 rows. - Select everything from the tablel - -Use AdventureWorks database I --2. Write a query to list the SalesorderID, SalesorderDetailID, ProductID, orderQty from SalesorderDetail tablel --3. Write a query to list the SalesorderID, TerritoryID from SalesorderHeader table. I --4. Write a query to list the name of the Product, ProductID, OrderQty I - - and SalesorderId by joining Product and SalesorderDetail Tables --5. Write a query to list the name of the Product, ProductID, Total orderQty by ProductID - by joining Product and SalesorderDetail Tables - 6. Pick a SalesorderID from SalesorderDetail table and find the total orderQty and Average UnitPricel
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
