December 13, 2009

SQL 作業二

(1)請查詢3號員工所處理的全部訂貨總價(單價*數量)

SELECT SUM(UnitPrice*Quantity) AS 訂貨總價
FROM OrderDetails
WHERE OrderID IN
(SELECT OrderID
FROM Orders
WHERE EmployeeID IN (3));


(2)請查詢出年紀最大的員工編號

SELECT EmployeeID AS 員工編號
FROM Employees
WHERE BirthDate IN
(SELECT min(BirthDate)
FROM Employees);


(3)請查詢出年紀最大的員工所處理的全部訂貨總價(單價*數量) (Join,Group By,Having,SubQuery ,聚合函數)

SELECT SUM(UnitPrice*Quantity) AS 訂貨總價
FROM OrderDetails
WHERE OrderID IN
(SELECT OrderID
FROM Orders
WHERE EmployeeID IN
(SELECT EmployeeID
FROM Employees
WHERE BirthDate IN
(SELECT min(BirthDate)
FROM Employees)));

由 b114097076 發表於 December 13, 2009 07:38 PM
迴響

sale uggs,cheap uggs,uggs outlet,all types of uggs on sale|uggs for cheap. Uggs online shops sale uggs in cool manners.
uggs outlet is available of boots coming in colors and styles, including uggs UK and cheap uggs|uggs online
Uggs Bailey Button|Uggs Classic Tall Boots|Uggs Cardy Boots

Posted by: sale uggs 發表於 October 8, 2010 10:44 AM

Our Coach Bags outlet is known for its bags with exclusive design. As one of the top and most well known shop, Coach Handbags is the true meaning of fashion trends! If you are a fashion oriented person, you should choose us, for it means fashion and bring you more confident and energy. Coach Outlet Store will absolutely alter your life into a heaven of enjoyment! As long as you open our Coach Outlet Store Online homepage, you may find various kinds of brand best Coach products on sale. Like the Coach Wallets and Coach Shoes which are a great gifts and the perfect equipment in our daily life. Make a choice of your favorite color or style, do not let these unique Coach goods slip away from you. Sincerely welcome to visit.gucci shoes
CHEN

Posted by: Coach Bags 發表於 June 9, 2011 10:59 AM

It supra footwearturns out that nicotine can
Supra Bullet Shoesrev up brain cells that
Real Air Jordan 1 Phat Lownormally signal people to
Air Jordan 1 Shoesstop eating when they're full,
monster energy hats for saleresearchers report in Friday's
Monster Energy Hatsedition of the journal Science.

Posted by: supra footwear 發表於 June 10, 2011 10:18 AM

Their Timberlands For Men include the 6 Inch Boot, Earthkeepers, Euro Hiker and Field Boots, but in the Cheap Timberlands are known as the “beef and broccolis” or the Shoes Timberland depending on their style and colorway. Rappers sweat timberland men shoes, Jadakiss, Cam’ron and Drake regularly rock these classics in their videos and Timberland For Kids. Busta Rhymes even paid homage to the Timberland boot in his song Timberlands For Cheap The desire for Timberland shoes reached a new level of insanity when J-Lo debuted a high-heeled version of Timberland Sale designed by stiletto stud, Manolo Blahnik.

Posted by: timberlanddiscounted 發表於 October 12, 2011 11:24 AM

So many people have seemingly given up on ever having the life they want. Life truly wears them down and out and there is nothing but a shell of a person left

Posted by: Air Jordan Heels 發表於 November 3, 2011 10:40 AM

good .i agree with you

Posted by: ralph lauren down vest 發表於 November 5, 2011 01:36 AM

http://www.cheapugg-boots-online.com
http://www.uggsforcheap-usa.com
http://www.uggsoutlet-usa.net

Posted by: cheap ugg boots online 發表於 November 5, 2011 03:03 PM

Have you ever dreamed of being as charming as Madonna? Have you ever thought of becoming an envy of all your friends? If so, come to Louis Vuitton Outlet.

Posted by: louis vuitton outlet 發表於 November 7, 2011 08:51 AM

http://www.snowbootsweb.net/ UGG Classic Tall
http://www.snowbootsweb.net/ UGG Classic Short
http://www.snowbootsweb.net/ UGG Bailey Button
http://www.snowbootsweb.net/ UGG Classic Cardy
http://www.snowbootsweb.net/ UGG Sundance
http://www.snowbootsweb.net/ Bailey Button 5803
http://www.snowbootsweb.net/UGG-Classic-Tall-5815-Boots-cxc-1.html UGG Classic Tall 5815 Boots
http://www.snowbootsweb.net/UGG-Classic-Short-5825-Boots-cxc-2.html UGG Classic Short 5825 Boots
http://www.snowbootsweb.net/UGG-Bailey-Button-5803-Boots-cxc-3.html UGG Bailey Button 5803 Boots
http://www.snowbootsweb.net/UGG-Bailey-Button-Triplet-1873-Boots-cxc-4.html UGG Bailey Button Triplet 1873 Boots
http://www.snowbootsweb.net/UGG-Classic-Cardy-5819-Boots-cxc-5.html UGG Classic Cardy 5819 Boots
http://www.snowbootsweb.net/UGG-Sundance-5325-Boots-cxc-6.html UGG Sundance 5325 Boots
http://www.snowbootsweb.net/UGG-Kids-Boots-cxc-7.html UGG Kids Boots
http://www.snowbootsweb.net/UGG-Classic-Argyle-Knit-5879-Boots-cxc-8.html UGG Classic Argyle Knit 5879 Boots
http://www.jacketsdowncoats.com/ Moncler Jackets
http://www.jacketsdowncoats.com/ Moncler Coats
http://www.jacketsdowncoats.com/ Moncler Down Jackets
http://www.jacketsdowncoats.com/ Moncler Down Coats
http://www.jacketsdowncoats.com/ Cheap Moncler
http://www.looknike.net/ Lebron VIII
http://www.looknike.net/ Nike Zoom Hyperfuse
http://www.looknike.net/ Kobe VI
http://www.looknike.net/ Air Max 90
http://www.looknike.net/ Kevin Durant Shoes
http://www.looknike.net/ Air Force One
http://www.sportsjerseysclub.org/ cheap jerseys
http://www.sportsjerseysclub.org/ Wholesale jerseys
http://www.sportsjerseysclub.org/ cheap nfl jerseys
http://www.sportsjerseysclub.org/ nfl Jerseys
http://www.sportsjerseysclub.org/ nhl jerseys
http://www.sportsjerseysclub.org/ discount mlb jerseys

Posted by: UGG Bailey Button 發表於 November 8, 2011 03:49 PM

http://www.louisvuittonoutletonline4u.net

Posted by: Louis Vuitton Outlet 發表於 November 8, 2011 06:04 PM

Air Jordan Shoes can also be acknowledged merely as Jordan, AJ since the Nike manufacturer developed for Basketball superstar Michael Jordan. oxygen Jordan footwear merchandising of Nike corporation addresses the around the world and keeps primary on this line.Shoesmyways.com is dedicated to offer inexpensive Wholesale Jordan Shoes communicate worldwide. We've been on this market considering that 2005 and cooperated with lots of primary shoe factories situated in China to be sure that we are able to provide you factory variants of Cheap Jordan Shoes profit in the lowest price. Stable good quality guaranteed. You can see thorough photographs of true footwear used by ourselves. all of the products and services on our site are for cost-free transport to USA, Australia, Canada and so on.


Not merely would be the FC Barcelona inexpensive jordan footwear basically probably the most exclusive sneakers in his whole shoe line, they are a few of belonging to the perfect Jordan Sneakers
actually produced. But remain tuned, when the boys at Nike have something to accomplish about it, you can discover heading being far more of “the really finest basketball jordan retro one actually made” within our future.Air Jordan Sneakers This is reminiscent belonging to the time once the Korean instructors on Manchester United’s “Sharp” joke. In fact, they are not named Michael Jordan, but their nation of Jordan could be the English identify New Jordans 2011, in a few of decades ago the overseas speech translation, being translated as “Jordan”, nevertheless in use. Later, out of the U.S. NBA basketball giant, also acknowledged since the name, translated it into a manufacturer new era of Air Jordan shoes for sale. on this Asian Championships, Jordan could be the group with probably the most men and women had been satisfied to provide in one / four favored to be successful the last away from Iran and also the host chinese language program group lost for the last game, Jordan gamers genuinely such as the “AsianJordan “superior skills, willed, strike an unprecedented large level.

Posted by: Air Jordan Shoes 發表於 November 9, 2011 05:26 PM

Many popular Uggs On Sale style come out in each year,people want to have the personally styles of winter shoes for themselves.The Uggs Sale have many new designs in earch years.All the colors and sizes can be find easy online.The cheap price of Uggs For Sale is the first choose by people like online shipping!

Posted by: Uggs On Sale 發表於 November 9, 2011 05:27 PM

In the arrival of winter, Moncler Jackets appears that mom dynamics is not messing near to this season. inside the confront of chilly temperatures and wind large blizzards some illnesses happen. I should admit which i seriously desire that winter will start in 2011 after and even could possibly not have.

It is wishful thinking. If you are like me which have not acquired a ideal winter coat or you just want a fashionable update. No have to be concerned about. Moncler coats will supply comfort, warmth and display away your style taste. 1 of my favored clothing could be the Moncler Vests


Moncler outlet, healthy style design and purpose from the required sexy. everybody desires to search great and maintain warm. You can think that when you purchased the Moncler coat, you will cozy inside the worst climate days.

Many from the Moncler Online Shop, we are in a placement to choose, just like Moncler females prolonged straight down Jacket Black. It could be the most recent popular, specific design and quite fashion. What’s more, it fills 90% down. when you obtained it, you will come across that it worth paid. Friends, not as great as center operations, to buy one!

Posted by: Moncler Jackets 發表於 November 9, 2011 05:29 PM

It is time for change, possibly just from your boots. As we know now the boots plays an very important part from the complete dressing, we are able to determine one’s characters from your dressing. Ugg Boots Sale
on profit outlet profit is well-known all more than the globe and carries a wonderful reputation from your customers, while you see the ugg boots lower price clearance sale, you can come across it could be the most Discount Ugg Boots towards career and life. You are as lengthy since the attention, whilst the consideration loves you. Have a superb buying on the Ugg Classic Tall, the water-proof by organic world, so durable stitching and lone collectively make you can take satisfaction in a variance relaxing and warm. ugg profit on clearance has unique type with the boots with the vast majority with the customers, Ugg Classic Short is 1 considerable with the ugg australia outlet. It has great worth and great purchaser response given that arrive in to the market.

We are committed to delivering you with probably the most sought soon after styles, and have among the preferred collections of reliable Ugg Boots
.Office has among the biggest collections ladies Genuine UGG boots accessible in a very variety of colours, using a massive assortment of chestnut inexpensive genuine Discount Ugg Boots in a very selection of heights, such as the traditional Short, traditional Tall, Bailey key and also the Cardy Knitted. not just does this awesome shoes glimpse good, the traditional Tall and traditional brief boots characteristic suede uppers with lavish sheepskin interiors that mould towards condition of your foot enabling your ft being at system temperatures arrive bad weather or shine.so why wait...get your pair of sought soon after Classic Uggs united kingdom and prevent the disappointment in all those chilly winter months! carry a glimpse at our assortment of Ugg Slippers and our variety of Cheap Ugg For Sale as some cosy ear muffs, gloves and aviator hat. retain them all searching pristine using the Ugg Shoe treatment kit.

Posted by: Ugg Boots Sale 發表於 November 9, 2011 05:30 PM

good jacket.i love this ralph lauren jacket

Posted by: cheap ralph lauren jacket 發表於 November 12, 2011 01:42 AM

After a pleasant summer day GHD Outlet with a bit lower GHD Hair Straightener humidity this morning, the next weather GHD Hair Australia maker is moving in with its showery rains GHD IV Pure this evening. Much of it will be light GHD Blue Serenity GHD Black Butterfly Hair Straightener GHD Blue Butterfly with patches of moderate to heavy rain migrating through. There is a risk of only isolated lightning and thunder. Once GHD IV Rare GHD Purple Gift a weak wave disturbance Cheap GHD tracks northeastward across southeastern CT, RI then near Boston by dawn, the rain will taper off to spotty mist. So plan on a damp start tomorrow morning GHD Australia with some GHD Hair areas of fog but a slot of drier GHD Hair Straighteners air should scour out much of the low-level moisture resulting in a brightening sky and spells of sunshine through breaking clouds later in the morning into the afternoon. Warming to 80-85 GHD Australia inland and middle 70s along the coast will spike the instability and trigger a few scattered GHD IV Styler showers and boomers later in the afternoon. The muggy weather will be GHD Benefit shoved seaward as a cold frontal GHD IV Styling boundary pushes offshore tomorrow evening.

Posted by: GHD Outlet 發表於 November 14, 2011 03:08 PM

www.louisvuittonoutlet4sonline.com louis vuitton outlet Louis Vuitton (Louis Vuitton), he is history's most prominent French designers of leather goods, in 1854 in Paris, opened his own name the first suitcase shop. A century later, Louis Vuitton luggage and leather goods to become one of the best areas of the brand, and become a symbol of high society. Today, the Louis Vuitton brand has louis vuitton purses are not limited to design and sell high-end leather goods and luggage, but to become involved in fashion, accessories, shoes, bags, jewelry, watches, louis vuitton bags mass media, wine, etc. giant field trend indicators. LV suitcase from the early T stage in Paris a year now constantly changing LV fashion show, LV (Louis Vuitton) is able to stand in the international fashion industry has been the top position, louis vuitton handbagsproud home of luxury brands out, louis vuitton shoes in their own unique brand DNAa v

Posted by: louis vuitton outlet 發表於 November 15, 2011 11:58 AM


So Good post. I like to read it . All the cheap Jordan sale hot on cold winter now ! get them now with high quality and free shipping !

Posted by: Jordan 11 發表於 November 18, 2011 11:09 AM

Winter av. Sn? h?r tiden p? ?ret och vi har alltid 0 kontakter avst?nd. Vi b?rjar att b?ra en tjock jacka, jacka, tr?ja. ser

Att j?mf?ra tung. S? vintern, v?lja en bra jacka ?r nyckeln. Till exempel Ralph lauren jacket in winter Mycket bra

Mycket varmt, mycket bekv?m att b?ra, det ?r v?ldigt varmt tyg, ?nnu viktigare, t?l kyla, kroppen attacker mot moral.

Posted by: ralph lauren blazer 發表於 November 24, 2011 02:19 AM

For ladies, Louis Vuitton replica handbags are the best pieces to show their unique tastes and styles. If you love them, you can buy them in our site. To buy replica louis vuitton USA from our online shop will be your best choice! Replica Louis Vuitton USA is surely to order you best service and high quailty!Welcome to professional Louis Vuitton Sale Outlet Online to purchase Louis Vuitton pruducts of the best quality & enjoy professional Louis Vuitton Sale service. Louis Vuitton outlet store provides various kinds of Louis Vuitton goods on sale. We wish you enjoy yourdelf with free shipping in Louis Vuitton outlet store.

Posted by: louis vuitton replica 發表於 November 29, 2011 08:36 AM

バーバリーから、上品な色使いのバーバリーチェックを使用した個性的で上品なネクタイです。デザインにこだわる高品質なネクタイをお探しの方にぴったりで
す。

Posted by: バーバリーマフラー 發表於 December 6, 2011 11:26 AM

mother ora dovranno ticket attenzione, perché questa è l . a . hogan
Oxygen Michael hogan scarpe a couple of Messaggio tutte le colpe stanno indicando l'accordo segreto, l'accordo segreto attirato l'attenzione di tutti, alla great aveva Grandmother Bretagna, Stati Uniti elizabeth l'Alaska è che tipo www.hoganssitoufficiale-italian.net di firma not accordo segreto legati alla cosa, inside Alaska, alla great, quale prezzo da pagare. Inside qualità di giornalista, scavando leggere tutti my partner and i documenti è che l . a . chiave del successo, elizabeth, naturalmente, che low haya senso sulla foundation di cosiddette demonstrate elizabeth Oxygen Michael hogan scarpe 11 infondate.

Posted by: Hogan 發表於 December 8, 2011 06:13 PM

So you can buy the Jordan shoe of your choice before anyone does and flaunt it. Moreover, you can take advantages of specials and coupons.

Posted by: Jordan 12 Playoffs 發表於 April 18, 2012 04:33 PM

The Lebron 9 is the ninth signature sneaker in LeBron James shoe line. Designed by Jason Petrie, it is the first basketball shoe that features the Flywire technology and Hyperfuse construction in one silhouette.

Posted by: lebron 9 發表於 June 6, 2012 11:29 AM

Back in 1998, the Nike Atmosphere Max 90 seemed to be originally released in what the provider called "Hyper Blue" and it also was immediately an enormous hit with many people that thought they may want to take up jogging but who also planned to look good while performing it. Who was the particular famous comedian clearly "It's always better to seem good then become good? http://www.airmax90shoesales.com

Posted by: Nike Air Max 90 發表於 June 28, 2012 02:10 PM

Jordan Retro 7 shoes are difficult to purchase these days. Only insurance coverage are ardent lovers about the brand bother in search of them. Some on the internet stores do market original Jordan 7 Olympic shoes interior various unique design and style and sizes. In addition, they put " up " applied and extinct Jordan shoes readily available purchase but still you can't find low-priced Air conditioning Jordans. http://www.jordan7olympic.org

Posted by: Jordan Retro 7 發表於 July 10, 2012 02:24 PM

There are numerous Aaron Rodgers Jersey which are produced now besides for the avid gamers but additionally for supporters. These types of jerseys are only in nearby and on the web businesses that stocks them in sell or wholesale groundwork. These are realized because there are actually wide ranging avid enthusiasts trying to possess their chosen player's Aaron Rodgers Jersey Sales together with their numbers about it. http://www.green-bay-packers-jerseys.com

Posted by: Aaron Rodgers Jersey 發表於 July 14, 2012 09:32 AM

http://www.coachfactoryonlinesale2013.com/ Coach Factory Online
http://www.louisvuittoncanada2013.ca/ Louis Vuitton Canada

Posted by: Louis Vuitton Canada 發表於 November 30, 2012 05:01 PM

axnstjjd http://paydayloansukcxe.co.uk/ short term loan TwJVoJ http://paydayloansusacxe.com/ fast payday loan 1860 http://paydayloanscanadacxe.ca/ payday loan Alberta GVwUT

Posted by: short term loan 發表於 May 29, 2013 05:17 AM
發表迴響









記住我的資訊?





請依上圖輸入檢核碼: