题目内容
设供应商供应零件的关系模式为SP(Sno，Pno，Qty)，其中Sno表示供应商号，Pno表示零件号，Qty表示零件数量。查询至少包含了供应商“168”所供应的全部零件的供应商号的 SQL语句如下：SELECT SnoFROMSP SPXWHERE (37) (SELECT*FROM SP SPYWHERE (38) ANDNOTEXISTS(SELECT*FROM SP SPZWHERE (39) ))； （38）处填（）。
查看答案
搜索结果不匹配？点我反馈
更多问题
The Super Bowl is one of the biggest events on the advertising calendar, as companies vie to produce the most memorable and innovative ads. The battle for the National Football League’s ultimate prize attracts more viewers than anything else on American television and provides a "symbolic pulsetaking" for the advertising industry every February, says John Frelinghuysen, an analyst at Bain and Company, a consultancy. But this year the patient is in poor health. All the advertising slots(广告摊位) for the 2008 Super Bowl had been sold by the end of November 2007, despite the $ 2.6 million price of each. For 2009 the price has risen to $ 3 million, but at least, ten slots (out of 67) are still looking for a buyer. General Motors, which ran 11 ads on Super Bowl Sunday in February 2008, has already said that it will not run any in 2009. America’s two other big carmakers, Ford and Chrysler, are likely to follow suit. Tellingly, Monster com, an online job-search company, said recently that it was buying a slot. Instead of the usual parade of expensive ads paying tribute to American consumerism, 2009’s Super Bowl will reflect a country in recession and indicate a hard year for the advertising industry. Most forecasts for next year say that ad spending in America will decline by 5% or more. Much depends on the fate of the automotive industry: carmakers and dealers normally spend around $ 20 billion a year on advertising, but Chrysler and Ford scaled back their expenditure by more than 30% in the first nine months of 2008, and are expected to make further cuts in 2009 as they struggle for survival. The car industry’s situation will hurt all media, but especially television. Analysts at BMO Capital Markets predict that total spending on television ads will fall by almost 9% next year. Only newspapers, where a decline of 12% is expected, are forecast to fare worse. Carmakers have already shifted some of their advertising spending to the Internet, and are likely to go further in 2009. Car ads make up 25% of advertising revenues for local television channels, and carmakers have been among the most consistent buyers of high-priced ads on national television. So far local stations have been most affected by falling spending oil advertising. National stations have been safer, because they operate on longer-term contracts with advertisers. But in the New Year they will also feel the chill, as companies fail to renew their contracts. Television, which has remained strong as print media have lost advertising dollars and readers to the Internet, could enter a decline of its own. "Next on the list is TV stations," says Anthony Diclemente, a media analyst at Barclays Capital. What may the carmakers resort to for promoting their automobiles and cutting down expenditure
某企业，2006年度共计拥有土地65 000平方米，其中免费租给邻近部队训练占地 3 000平方米、幼儿园占地1 200平方米，企业内部绿化占地2 000平方米。2004年度的上半年企业共有房产原值4000万元，7月1日起企业将原值200万元、占地面积400平方米的一栋仓库出租给某商场存放货物，租期1年，每月租金收入1.5万元。8月10日对委托施工单位安装中央空调的生产车间办理验收手续，由在建工程转入固定资产原值500万元，单项核算(城镇土地使用税4元/平方米；房产税计算余值的扣除比例20%)。 要求：(1)计算该企业2004年应缴纳的城镇土地使用税。 (2)计算该企业2004年应缴纳的房产税。
某数据库中有供应商关系S和零件关系P，其中，供应商关系模式S(Sno,Sname,Szip,City)中的属性分别表示：供应商代码、供应商名、邮编、供应商所在城市；零件号、零件名；颜色、重量、产地。要求一个供应商可以供应多种零件，而一种零件可以由多个供应商供应。请将下面的SQL语句的空缺部分补充完整。CREATE TABLE SP (Sno CHAR(5)，Pno CHAR(6)，Status CHAR(8)，Qty NUMERIC(9),(32) (Sno,Pno)，(33) (Sno)，(34) (pno)；查询供应了“红”色零件的供应商号、零件号和数量(QTY)的元组演算表达式为：t|(u|$)($V)($w)( (35) ^u[1]=v[1]^v[2]=w[1]^w[3]=’红’^ (36) ) （33）处填（）。
Questions 22 ～ 25 are based on the following passage. Who paid the bill for the lunch
微信支付 
支付宝支付