Intermediate SQL (basic queries for finance)

Test your Intermediate-level Data Analysis Tools Sql Basic Queries For Finance skills in Tools Systems. This timed assessment evaluates your expertise in Accounting.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

You need to find all customer accounts whose balance, calculated as SUM(debit) - SUM(credit), is below zero. Which query structure is correct?

A. GROUP BY account_id HAVING SUM(debit) - SUM(credit) < 0

B. WHERE SUM(debit) - SUM(credit) < 0 GROUP BY account_id

C. GROUP BY account_id WHERE balance < 0

D. HAVING balance < 0 GROUP BY account_id

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question