Find the set of all customers satisfying the property that for each the total value of his or her accounts is at least S1,000,000.

Use SQL:1999/2003 and the schema constructed for the previous exercise to answer the following queries:



SELECT C.Name
FROM Customers C
WHERE sum(C.Accounts->Balance) > 1000000

Computer Science & Information Technology

You might also like to view...

A method-message can only be sent from a place where a(n) ____ can appear.

A. comment B. variable C. attribute D. statement

Computer Science & Information Technology

In the following code segment, what type of variable is counter?

``` Dim temp, counter, check As Integer Do temp = CInt(InputBox("Enter a number.")) counter += temp If counter = 10 Then check = 0 End If Loop Until (check = 0) ``` (A) counter (B) accumulator (C) sentinel (D) loop control variable

Computer Science & Information Technology

You can add calculated fields to a report using drag-and-drop

Indicate whether the statement is true or false

Computer Science & Information Technology

What is the maximum number of fields that can be sorted in a single sort?

A) 64 B) 8 C) 16 D) 32

Computer Science & Information Technology