Answered step by step
Verified Expert Solution
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
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 ^ pngStep 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