Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

- 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions