STK卡与普通SIM卡的区别在于,在STK卡中固化了应用程序。通过软件激活提供给用户一个文字菜单界面。这个文字菜单界面允许用户通过简单的按键 *** 作就可实现信息检索,甚至交易。例如终端用户想查询天气预报,在没有STK增值服务的情况下,用户需要手动编辑短消息"TQ 010",再将短消息发送到168服务平台。这样用户需要记住"TQ"是天气预报的命令代码和168服务平台号。事实上命令代码有很多如"GP"代表股票查询,"HF"代表电话费查询等。因此要用户将所有的命令代码记住是不现实的也是很不方便的。STK通过固化在卡中的程序,提供给用户"天气预报"等菜单提示,这样用户只需要输入想要查询地区的长途区号即可查询到天气情况。从而使用户不必记忆命令代码和服务平台号,达到方便用户的目的。i
Report
the
value
of
each
stock
holding
in
UK
pounds
Sort
the
report
by
nation
and
firm
SELECT
bSTKCODE,bSTKFIRM,bSTKPRICEaExchange_Rate
AS
STKPRICE_NEW
FROM
nation
a
,stockinfo
b
WHERE
bnatcode=anatcode
ORDER
BY
bnatcode,bSTKFIRM
ii
Report
by
nation
the
total
value
of
stockholdings
SELECT
NATCODE,
sum(STKPRICESTKQTY)
AS
Tal_stockholdings
FROM
stockinfo
GROUP
BY
natcode
iii
Report
the
number
of
stocks
and
their
total
value
by
nation
SELECT
NATCODE,
COUNT(STKPRICESTKQTY)
AS
tal_num,sum(STKPRICESTKQTY)
AS
Tal_value
FROM
stockinfo
GROUP
BY
natcode
iv
Report
the
total
value
of
stocks
for
nations
with
two
or
more
listed
stocks
SELECT
NATCODE,
sum(STKPRICESTKQTY)
AS
Tal_stockholdings
FROM
stockinfo
GROUP
BY
natcode
HAVING
COUNT(STKPRICESTKQTY)>=2
v
How
many
firms
are
in
the
stock
portfolio
SELECT
COUNT()
FROM
stockinfo
vi
How
many
firms
have
stockholdings
greater
than
30000
SELECT
COUNT()
FROM
stockinfo
WHERE
STKQTY>=30001
vii
Find
the
average
dividend
SELECT
AVG(aSTKDIVbExchange_Rate)
AS
avg_div_pd
FROM
stockinfo
a
,
NATION
b
WHERE
anatcode=bnatcode
viii
What
is
the
average
yield
for
the
portfolio
SELECT
AVG((aSTKDIVSTKQTY)bExchange_Rate)
AS
avg_div_pd
FROM
stockinfo
a
,
NATION
b
WHERE
anatcode=bnatcode
Remarks:I
don't
know
what's
your
tablename
of
the
table
you
put
the
stock
portfolio
in
,so
I
set
it
"stockinfo",and
I
wish
you
can
think
about
it
that
why
I
wirte
it
like
that
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)