Question 15 pts

Write a sql statements to do the following:

Display Account Number and Name column from Vendor table. Return only Vendors that have Credit rating of 1 and Active Flag set to 1.

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 25 pts

Write a ql statements to do the following:

Display First Name, Last Name and Email Address columns from Contact table. Return only those contacts that have an Email promotion of 1 or 2

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 35 pts

Write SOL statements to do the following:

 Return columns CustomerID, TerritoryID and AccountNumber from Customer table. Return only those customers that belong to Territories Northwest, Central, France and  United Kingdom. Review the SalesTerritory table to get TerritoryID for each territory. In this SOL statement use the IN operator..

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 45 pts

Write sql statements to do the following:

Display the First Name, Middle Name and Last Name columns for everyone from the Contact table whose Last Name ends with “ms.” Also write code to make sure all Middle Names are returned in Upper case.

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 55 pts

Write SOL statements to do the following:

Display all columns for everyone in the Contact table whose First Name contains  “ll”

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 65 pts

Write SOL statements to do the following:

Display Account Number and Name from the  Vendor table  whose Name begins with B or L

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 75 pts

Write SQL statements to do the following:

Display all columns for everyone whose Middle Name is NULL from the Contact table.

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 85 pts

Write SOL statements to do the following:

Display Name and Product Number columns from the Product table. Concatenate both columns to create a new column with alias name "ProductName". Write code to make sure and remove any Right and Left spaces on both the Name and Product Number columns. 

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 95 pts

Write SOL statements to do the following:

Return columns ProductID and OrderQty from the SalesOrderDetail. Also, 

multiply the OrdeQty by the UnitPrice to create new column with alias name “TotalOrderCost”

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

p   Flag this QuestionQuestion 105 pts

Write SOL statements to do the following:

Display Name, Product Number and List Price columns from Product Table. Return only those records where ListPrice not equal to 249.79

HTML EditorKeyboard Shortcuts

 Font SizesParagraph

Question 14 pts  What operator do you use to filter by more than one column?

  Flag this Question Question 24 pts If you had two conditions in WHERE clause which operator should you use to match either condition? 

  Flag this Question Question 34 pts Of the three answers below, which operator ranks higher in order of evaluation? 

  Flag this Question Question 44 pts A WHERE clause is used to filter data. With a WHERE you can also do what? 

  Flag this Question Question 54 pts Which of the following are true statements regarding the use of WILDCARDS 

  Flag this Question Question 64 pts A search pattern is defined as "a search condition made up of literal text, wildcard characters or any combination of the above." 

  Flag this Question Question 74 pts The LIKE operator is not an operator it is a predicate. 

  Flag this Question Question 84 pts Some database systems are configured as case-sensitive. In case-sensitive configurations, a search like %fish% will not match "FISH bean bag toy."  

  Flag this Question Question 94 pts An Alias as an alternate name for a field 

  Flag this Question Question 104 pts Using a WILDCARD you can create search patterns that can be compared against your data. 

ComputerScienceExpert

(11)

Status NEW Posted 12 May 2017 01:05 AM My Price 11.00

-----------

Attachments

file 1494552752-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer