The following three equations represent words that have a common relationship. The first letter of each word is given. Where will you find the following equations to be true?
R = 1, S T = 2, T = 6
note: S T refers to a two-word variable
2007-02-11 13:23:54 · 5 answers · asked by Anonymous in Entertainment & Music ➔ Jokes & Riddles
Canadian Football League, the point values for various types of scoring
a Rouge is 1 point (R = 1)
a Safety Touch is 2 points (S T = 2)
a Touchdown is 6 points (T = 6)
2007-02-11 13:57:58 · answer #1 · answered by Anonymous · 0⤊ 0⤋
If the query isn't immediately obvious, break it down piecemeal until it is: 1) What orders included item ln2? SELECT orderNumber FROM LineItem WHERE itemNumber = "ln2" 2) Who placed those orders (eliminating duplicates)? SELECT DISTINCT custId FROM Order o JOIN LineItem l ON o.orderNumber = l.orderNumber WHERE itemNumber = "ln2" 3) What are those customers names and addresses? SELECT lastName, firstName, address FROM customer WHERE custId IN (SELECT DISTINCT custId FROM Order o JOIN LineItem l ON o.orderNumber = l.orderNumber WHERE itemNumber = "ln2") Edit: Semper's answer is fine as well, as long as you don't mind duplicates from customers who ordered it more than once.
2016-03-29 02:49:41 · answer #2 · answered by Anonymous · 0⤊ 0⤋
You do know that there are other parts of Yahoo Answers, don't you? If you don't, there are. Now you know. STOP putting MATH in the JOKES AND RIDDLES section.
2007-02-11 13:30:54 · answer #3 · answered by Nick R 4 · 0⤊ 0⤋
the ST because it = 2 and it has 2 letters?!?! am i rite?!?!
2007-02-11 13:29:41 · answer #4 · answered by ♪-~`*guitar♫chick*`~-♪ 3 · 0⤊ 0⤋
no LOL
2007-02-11 13:33:46 · answer #5 · answered by Tigerluvr 6 · 0⤊ 0⤋