Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone help please? N California State University, North N Cenvas Caiformia la State Univers Univers XQuiz: Quiz 02-SQL C ia https://canvas.csun.edu/courses/52563/quizzes/126944/take Portfolium CSUN Question

image text in transcribed

can someone help please?

N California State University, North N Cenvas Caiformia la State Univers Univers XQuiz: Quiz 02-SQL C ia https://canvas.csun.edu/courses/52563/quizzes/126944/take Portfolium CSUN Question 1 20 pts While CustomerlD is typically on Sales Orders and not on SOLines, I assume it is on SOLines to simplify the SQL SELECT FROM Customers Who are our vendors? Aggregate sales orders by customer. Which Customers are Inactive? List customers by customer name. List Items by Item Name. Which Customers are Active? Find all of the item information for a specific Item. Who are our customers? List Items by Sales Price from most expensive to least expensive What Items do we sell? Which Vendors are Active? Which Items are Inactive? Who are our vendors? Which Items are Active? SELECT FROM Vendors SELECT FROM Items SELECT CustomerName, CustomeriD FROM Customers WHERE Status Active" SELECT ItemID, ItemName FROM Items WHERE Status "Active SELECT CustomerName, CustomerID FROM Customers ORDER BY CustomerName ASC I Choose SELECT ItemName, ItemID FROM Items ORDER BY ItemName ASC I Choose ] SELECT ItemName, ItemlD, Price FROM Items ORDER BY Price DSC I Choose ] media-col-col3d Show allX ^ png

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

Students also viewed these Databases questions