Question

Using the Cash table below, show the output for the following SQL query: (Using the dropdowns, identify which rows and columns would included in the SQL query output shown below. Select "Not included" for rows and columns that would not be included in the output.)

SELECT Account#, Balance

FROM Cash

WHERE Bank = ‘Boston5’

ORDER BY Amount DESC;

Cash Account # Type Bank Balance 253 48.000 75,000 950 Checking Checking Draft Checking ncluded BA-6 BA-7 ot Included BA-8 BA-9 Boston 5 Shawmut Shawmut Boston5 ncluded ncluded

Answer 1

Cash	Included	Not Included	Not Included	Included
	Account #	Type	Bank	Balance
Included	BA-6	Checking	Boston 5	253
Not Included	BA-7	Checking	Shawmut	48000
Not Included	BA-8	Draft	Shawmut	75000
Included	BA-9	Checking	Boston 5	950