Correct answer is A. The key is to consider all LineNo are selected... When joining two tables:
OrderID1: 90, LineNO 93001776
OrderID2: 500, but we get three different LineNo: 93001776, 93001665 and 93001667, therefore it would be 500x3 = 1500
OrderID3: 100, does not match second table, therefore LineNo is null
OrderID4: 120 but there is no match with the second table, therefore LineNo is null.
Hence, if we select all LineNo, the result would be 90 + 500*3 = 1590... If we do not filter by LineNo, then the result would be 1810.
Filter the Orders table based on these OrderID values
From the Orders table, the OrderNetAmount values for OrderID 1, 2, and 3 are:
OrderID 1: 90
OrderID 2: 500
OrderID 3: 100
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
minikiu00
1 week, 6 days agoJdossa91
2 weeks, 5 days ago7d737d9
2 months, 2 weeks ago