Answered step by step
Verified Expert Solution
Question
1 Approved Answer
- 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started