Question: Problem 4 [ 2 0 = 5 * 2 + 5 + 5 ] Consider the following tablei ) Order ( OrderID , CustomerID, OrderDate
Problem Consider the following tablei Order OrderID CustomerID, OrderDate OrderItems ItemID OrderID, ProductID, Quantity, Price Write an SQL query to find the total value of each order ie the sum of item prices for all items in the order Write a query to find all products that have been ordered at least once. ii Employees EmpoyeeID EmployeeName, Salary, ManagerID Write an SQL query to find the employees who earn more than their respective managers. iii Users UserID Interest Write an SQL query to find users who share common interests.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
