Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-24 : 08:19:19
|
| Alton writes "Exercises #1 Create an _expression to represent the concatenation of the fields: First Name, Middle Initial, Last Name with space between each field.Create an _expression to represent this formula: Quantity * List Price * (1 - Sale Discount)Create an _expression to represent a team's city followed by it's team logo name. Example: Philadelphia Eagles, Utah Jazz, Los Angeles Lakers. The city field is named: Locale. The team logo name is: Team Name.Create an _expression that represents the date that is 7 days after the date in the database. You can add days to a date by adding 1. If a date is 10/21/02 and you added 1 to the date, you would get 10/22/02. The date field is The_Date.Exercises #2 Write an _expression for the following that involves all three tables. Do not write the query, just write the _expression. See above for the definition of an _expression.Write an _expression that will produce a schedule of match ups based on field values such as: 1994: Philladelphia Phillies vs. Toronto Blue JaysWrite an _expression that will show the number of games won (Wins field) by each team in a given World Series: 1994: Phillies 2, Blue Jays 4Write an _expression that produces a single value of "True" or "False" to decide if the NL Team was the winner of the series. (Did the NL team have more wins than the AL Team?) Write an _expression that produces a single value of "True" or "False" to determine if the NL team won a specific game. (Was the NL_score more than the AL_score?) Write an _expression to evaluate to "True" of "False" to see if either the AL team or the NL team was from a locale name beginning with "New". (Use Like) Write an _expression that evaluates to "True" or "False" to see if the year is anywhere from 1990-2000. (Use Between) Write an _expression that produces a single value of "True" or "False" to see if the Home team won the game. The value of the field: "Home" will be either "AL" or "NL". (Is Home equal to "NL" and NL score higher than AL score - or - Is Home equal to "AL" and AL score higher than NL score?) This is a complex _expression, use parentheses to show which operations must be done first. Remember, the result is a single value of "True" or "False"." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-24 : 08:21:38
|
| Sorry, we don't answer homework or test questions. I suggest you do a search on "concatenation" and "expressions" in SQL Server Books Online if you want information on them. If you don't have BOL installed on your computer:http://www.sqlteam.com/redir.asp?ItemID=1849 |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-25 : 12:07:16
|
| The answers to your midterm is as follows1:A2:c3:c4:d5:b6:c7:aall the rest answer c for. I garentee you'll get a 25% average (well.. on average atleast)Heh, theres no easy way to get your homework done man... Those seem like very simple select statements too. Go learn SQL-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
|
|
|
|
|
SQL Expressions