SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 20 Dec 2017 My Price 10.00

STORE_LOCATION.CURRENCY_ACCEPTED_ID


SELECT CURRENCY.US_DOLLARS_TO_CURRENCY_RATIO FROM CURRENCY

JOIN STORE_LOCATION ON CURRENCY.CURRENCY_ID=STORE_LOCATION.CURRENCY_ACCEPTED_ID

WHERE STORE_NAME='Cancun Extension';

 

SELECT price_in_us_dollars *16.75 AS Price_in_Mexican_Peso

from PRODUCT

WHERE PRODUCT_NAME='Flowing Skirt';

 

16. In step 3 (see above), you are asked to give the price of a flowing skirt in Cancun by writing two

queries. You now have the skills to retrieve this in a single query! Do so now, making

sure to format the result as a currency. It is convention to use either “$” or “Mex$” as

the currency symbol for Mexican Pesos.

a. Capture the results of the query and its execution.

b. Explain how your solution makes use of a subquery to help retrieve the result, and

the advantages of your new solution over your solution in step 3.

 

DDL is attached below!

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 20 Dec 2017 12:12 PM My Price 10.00

-----------  ----------- 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

Not Rated(0)