SQL exerciseIntermediate20 min
DB2: answer three questions with SQL
The branch team has three questions about the fictional customer database (schema LEARNER: CUSTOMER, ACCOUNT, TRANSACTION). Write a SELECT for each in the SQL panel and run it. Each question is checked against the right answer.
What you will do
- Filter and sort
- Join and group
- Find missing rows with an outer join
Simulated: the Lab runs entirely in your browser on a simulated, fictional z/OS system. Nothing is sent to or run on a real mainframe.
Free, no account needed.
Your work is saved on this device; sign in to keep it in your account.