Database Changes SQL Topic exerciseBeginnerVerified answerSQLite + PostgreSQL live · 3 guided

Add a New Customer Account

Insert account 5 as Summit Health with tier growth, status active, and a 15000 credit limit.

  • INSERT
  • Explicit column lists

Exercise brief

Understand the request

Customer operations A new customer has passed onboarding and must be available to the order workflow.

Customer operations approved Summit Health as a new growth account.

Return

  • Create exactly one new account row.

Constraints

  • List the target columns explicitly.
  • Do not change existing accounts.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

accounts

  • account_idINTEGER
  • account_nameVARCHAR(100)
  • tierVARCHAR(20)
  • statusVARCHAR(20)
  • credit_limitINTEGER

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Hint 1

Use INSERT when you need to add a new row without changing existing records.

Hint 2

Name all five target columns before the VALUES clause so the mapping is explicit.

Hint 3

INSERT INTO accounts (account_id, account_name, tier, status, credit_limit) VALUES (...);

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

Reveal solution and explanation
INSERT INTO accounts (account_id, account_name, tier, status, credit_limit)
VALUES (5, 'Summit Health', 'growth', 'active', 15000);

Why this works

An explicit column list makes the insert resilient to column-order changes and documents which values are intentionally supplied.

Success check

The new account has the exact approved values and all four original accounts remain unchanged.

Learn the concepts behind this answer

Strengthen your understanding with these targeted learning topics:

Continue practicing

Build the next SQL skill

SQL Practice Online →

Open the interactive workspace and practice across SQL topics.