Book of tasks on programming. Old version

 

 by Aliaksandr N. Prykhodzka

 

tasks, винчестер, самообучение, Internet, text, xsl, browser, язык программирования, tree, disk, запрос, calculator, mod, восьмеричный, сохраненная процедура
 

for valuable work you must have JavaScript (allow active content)

SQL. S.4. Nest of tasks. Operator Inner Join, Group by

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.4.1     Answer

Determine number which is result of this Select-operator:


Select Sum(EE) from Tabl3 Inner Join Tabl2 where DD=CC

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.4.2     Answer

Determine number which is result of this Select-operator:


Select Count(EE) from Tabl3 Inner Join Tabl2 where DD=CC

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.4.3     Answer

Determine quantity of records fetched by this Select-operator:


Select Sum(EE) from Tabl3 Inner Join Tabl2
where DD=CC group by DD

 

©   Aliaksandr Prykhodzka    1993 - 2007